gpt4 book ai didi

mysql - MS Access 前端/MySQL 后端兼容和推荐的数据类型

转载 作者:行者123 更新时间:2023-11-29 02:37:54 26 4
gpt4 key购买 nike

当使用 Microsoft Access 作为前端时,我需要一个推荐的 MySQL 数据类型列表。谁能给我指点网上一篇简洁的文章,或者在这里发布一个列表?

最佳答案

看看这个:Using Connector/ODBC with Microsoft Applications

For all versions of Access, you should enable the Connector/ODBC Return matching rows option. For Access 2.0, you should additionally enable the Simulate ODBC 1.0 option.

You should have a TIMESTAMP column in all tables that you want to be able to update. For maximum portability, do not use a length specification in the column declaration (which is unsupported within MySQL in versions earlier than 4.1).

...

Access cannot always handle the MySQL DATE column properly. If you have a problem with these, change the columns to DATETIME.

....

关于mysql - MS Access 前端/MySQL 后端兼容和推荐的数据类型,我们在Stack Overflow上找到一个类似的问题: https://stackoverflow.com/questions/2222748/

26 4 0
Copyright 2021 - 2024 cfsdn All Rights Reserved 蜀ICP备2022000587号
广告合作:1813099741@qq.com 6ren.com