MySQL: How to avoid case sensitivity in SQL queries when migrate from Windows to Linux?
2
votes
4
answers
11827
views
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 ?
Asked by ursitesion
(2061 rep)
May 8, 2014, 05:23 AM
Last activity: Jul 7, 2024, 01:23 PM
Last activity: Jul 7, 2024, 01:23 PM