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 variablemysql>

其中：（0：区分；1：不区分）

如果要想不区分大小写话：

可以修改my.ini或者my.cnf

[mysqld]

lower_case_table_names=1