mysql查询单表大小写_MySQL查询中区分大小写的表名

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 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

will succeed while

select * from MY_TABLE

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

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.