用于处理表名中的区分大小写的PHP MYSQL配置

Question

In my application database some of the tables are names in lowercase letters and some are in upper case. I want to male my database to run queries via PHP without considering the case of tables.

On amazon RDS instance I have set the value of lower_case_table_names=1 for making my database case insensitive.

When I run the query in HeidiSQL or Phpmyadmin with lower case table names then I am able to run the queries. But when I run the same queries via PHP file, the query does not runs and table name does not exist error is shown.

Is there any other setting in PHP side that I needs to do?

Answer 1

update your mysql configuration file: /etc/mysql/my.cnf to set

lower_case_table_names = 1

then restart mysql

after setting your lower_case_table_names = 1, you should import your database then drop it and recreate again.