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