Sample Header Ad - 728x90

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