mysql> show variables like 'lower_case_table_names';  
+------------------------+-------+
| Variable_name          | Value |
+------------------------+-------+
| lower_case_table_names | 0     |
+------------------------+-------+
1 row in set (0.01 sec)

mysql> set global lower_case_table_names=1;
ERROR 1238 (HY000): Variable 'lower_case_table_names' is a read only variable
mysql> set lower_case_table_names=1;       
ERROR 1238 (HY000): Variable 'lower_case_table_names' is a read only variable
mysql>

默认是0，代表区分大小写，改为1，为不区分大小写。此参数不支持动态修改，需要在my.cnf里增加lower_case_table_names=1，然后重启MYSQL数据库即可。

mysql> show tables;
+----------------+
| Tables_in_test |
+----------------+
| car            |
| test1          |
| test2          |
| user           |
| user_201112    |
| user_201201    |
| user_201202    |
| user_201203    |
+----------------+
8 rows in set (0.00 sec)

mysql> select * from TEST2;
+----+------+------+
| id | tid  | name |
+----+------+------+
|  2 |    2 | bb   |
|  3 |    3 | cc   |
|  4 |    4 | NULL |
|  6 |    4 | ee   |
+----+------+------+
4 rows in set (0.04 sec)

mysql> select * from test2;
+----+------+------+
| id | tid  | name |
+----+------+------+
|  2 |    2 | bb   |
|  3 |    3 | cc   |
|  4 |    4 | NULL |
|  6 |    4 | ee   |
+----+------+------+
4 rows in set (0.00 sec)

 

本文转自 liang3391 51CTO博客，原文链接:http://blog.51cto.com/liang3391/842969