I'm having an issue with a website I wrote in PHP on a WAMP server on Windows, issue is, it's now being deployed on a Linux server. The site is quite big and I've done all my queries this way in all caps:
"SELECT COLUMN FROM TABLE"
And most of the tables/columns in the database use a different case (For example, Column).
I cannot use lower_case_table_name=1 since there are other PHP websites on the server that would be affected negatively. Is there a way for me to switch all of my database's tables and columns into upper case?
you have change the names of columns and tables if you database is not so huge you can try this
select concat('rename table ', column_name, ' to ' , lower(column_name) , ';')
from information_schema.columns where table_schema = 'your_schema_name';
and rename or change the case for more help see and lower_case_table_names
ALTER TABLE yourtablename RENAME TO YOURTABLENAME;