mysql查看是否区分大小写

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

转载于:https://blog.51cto.com/alwaysyunwei/1357329