Difference between revisions of "Disabling case-sensitive checking for table and column names in MySQL"
From Notes_Wiki
(Created page with "=Disable case-sensitive checking in MySQL= On Operating Systems like Windows where filesystem is case-insensitive MySQL would be case-insensitive by default. But on operating...") |
m |
||
| Line 7: | Line 7: | ||
There are other MySQL variables other then this which can help in changing the behavior of MySQL. Use '<tt>show variables</tt>' command to see values of variables. We can also use 'SET GLOBAL <variable_name>=<value>;'syntax for changing values of variables on running MySQL. | There are other MySQL variables other then this which can help in changing the behavior of MySQL. Use '<tt>show variables</tt>' command to see values of variables. We can also use 'SET GLOBAL <variable_name>=<value>;'syntax for changing values of variables on running MySQL. | ||
Back to [[Mysql configuration]] | |||
Revision as of 23:07, 17 November 2012
Disable case-sensitive checking in MySQL
On Operating Systems like Windows where filesystem is case-insensitive MySQL would be case-insensitive by default. But on operating systems like Linux MySQL is case-sensitive. To disable case-sensitivity in Linux we can add following line in '/etc/my.cnf' and restart mysqld service.
lower_case_table_names=0
There are other MySQL variables other then this which can help in changing the behavior of MySQL. Use 'show variables' command to see values of variables. We can also use 'SET GLOBAL <variable_name>=<value>;'syntax for changing values of variables on running MySQL.
Back to Mysql configuration
