查看大小写区分
mysql> show variables like "%case%";
+------------------------+-------+
| Variable_name | Value |
+------------------------+-------+
| lower_case_file_system | OFF |
| lower_case_table_names | 0 |
+------------------------+-------+
2 rows in set (0.00 sec)
让MYSQL不区分表名大小写的方法:
1.用ROOT登录,修改/etc/my.cnf2.在[mysqld]下加入一行:lower_case_table_names=1
3.重新启动数据库即可