mysql中表名不区分大小写

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.ini的[mysqld]里增加lower_case_table_names=1，然后重启MYSQL数据库即可:net stop mysql。