永久设置

[mysqld]
# 0 区分大小写，1不区分大小写
lower_case_table_names=1

查看是否启动忽略大小写

MySQL [zx_lw]> SHOW VARIABLES LIKE '%case%';
+------------------------+-------+
| Variable_name          | Value |
+------------------------+-------+
| lower_case_file_system | OFF   |
| lower_case_table_names | 0     |
+------------------------+-------+

修改表名

alter table 旧表名 rename 新表名;