Difference between revisions of "Disabling case-sensitive checking for table and column names in MySQL"
From Notes_Wiki
m |
m |
||
| Line 8: | Line 8: | ||
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. | ||
Revision as of 08:08, 2 December 2012
<yambe:breadcrumb>Mysql configuration</yambe:breadcrumb>
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.
