I have migrated my Database from Windows to Linux server. In many places, query has been written without focusing their cases (uppercase / lowercase). So, these queries are not getting executed and generating errors. As a result, functionalities based on these queries are breaking. Below is the example query to run in Windows and Linux:
Select A.id,A.title from tablename a;
This query will work in Windows while never work in Linux.
- Is there any way through which I can avoid these case sensitivity in MySQL queries and no need to check and fix every query ?