php - mysql case sensitive table names in queries

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.

Answer

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.