MySQL查询中区分大小写的表名 [英] mysql case sensitive table names in queries

问题描述

我有php代码，其中数据库表名的第一个字母用大写字母表示，但是数据库中表名用小写字母表示.

I have php code where first letter of database table names is in capital letter every where but table names in database are in lowercase.

我应该使用什么全局设置，这样就不必在每个代码文件中都进行更改来以与数据库相同的方式来创建表名.

What global setting should I use so that no need to change in every code file for making table names in same case as in database.

推荐答案

MySQL默认情况下，MySQL元数据区分大小写.也就是说，如果您有一个表my_table(小写)，则

MySQL metadata is case sensitive by default on Linux. That is if you have a table my_table, in lower case, then

select * from my_table

将会成功

select * from MY_TABLE

将失败，并显示某种表格不存在的消息.

will fail with some sort of table doesn't exist message.

如果您希望两个语句都成功，则需要在下面加上 lower_case_table_names = 1 在您的/etc/my.cnf或您保留MySQL配置的任何位置.确保将系统变量添加到配置文件的[mysqld]部分.

If you want both statements to succeed, you need to put the following line lower_case_table_names = 1 in your /etc/my.cnf or wherever you keep your MySQL configuration. Be sure to add the system variable to [mysqld] section of the configuration file.

这篇关于MySQL查询中区分大小写的表名的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！