mysql> show variables like '%case_table%'; +------------------------+-------+ | Variable_name | Value | +------------------------+-------+ | lower_case_table_names | 0 | +------------------------+-------+ 1 row in set (0.00 sec) mysql> set global lower_case_table_names=1; ERROR 1238 (HY000): Variable 'lower_case_table_names' is a read only variable mysql>
其中:(0:区分;1:不区分)
如果要想不区分大小写话:
可以修改my.ini或者my.cnf
[mysqld]
lower_case_table_names=1