gpt4 book ai didi

mysql - 如何在Linux环境中禁用区分大小写

转载 作者:行者123 更新时间:2023-11-30 00:51:30 25 4
gpt4 key购买 nike

我正在 Ubuntu 机器上使用在 Windows 机器上创建的 MySQL 架构。但是当我的应用程序尝试访问数据库时,我得到了

Table 'schema.Booking' doesn't exist

如何禁用此功能以使存储过程不区分大小写?

最佳答案

Use lower_case_table_names=0 on Unix and lower_case_table_names=2 on Windows. This preserves the lettercase of database and table names. The disadvantage of this is that you must ensure that your statements always refer to your database and table names with the correct lettercase on Windows. If you transfer your statements to Unix, where lettercase is significant, they do not work if the lettercase is incorrect.

参见:http://dev.mysql.com/doc/refman/5.0/en/identifier-case-sensitivity.html

关于mysql - 如何在Linux环境中禁用区分大小写,我们在Stack Overflow上找到一个类似的问题: https://stackoverflow.com/questions/20933120/

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