mysql不区分大小写

配置很简单

[root@rbd02 gr817cf2-0]# cat my.cnf 
[mysqld]
lower_case_table_names = 1

有个前提是

修改配置文件之前，数据库里面的表不能为大写，想办法转换成小写即可。

配置完之后重启mysql即可

验证

mysql> show tables;
+---------------------+
| Tables_in_test |
+---------------------+
| ip_dca_audit_result |
+---------------------+
1 row in set

mysql> desc IP_DCA_AUDIT_RESULT;
+--------------------------------------+--------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+--------------------------------------+--------------+------+-----+---------+-------+
| 8269fa8789df4ddbbf948ca0eb4d923c | varchar(255) | YES | | NULL | |
| f2 | varchar(255) | YES | | NULL | |
| 20002 | varchar(255) | YES | | NULL | |
| 02018052800006 | varchar(255) | YES | | NULL | |
| 0522test003 | varchar(255) | YES | | NULL | |
| 2e6e6b28-8bb0-450c-b0da-7e41500b7b66 | varchar(255) | YES | | NULL | |
| 27ce57093aa8f74e84ac3a9c2246656e | varchar(255) | YES | | NULL | |
| ps | varchar(255) | YES | | NULL | |
| f9 | varchar(255) | YES | | NULL | |
| f10 | varchar(255) | YES | | NULL | |
| ps1 | varchar(255) | YES | | NULL | |
| cancel | varchar(255) | YES | | NULL | |
| data_process_error | varchar(255) | YES | | NULL | |
| 2018/6/5 19:24:03 | varchar(255) | YES | | NULL | |
| system | varchar(255) | YES | | NULL | |
| 2018/6/5 19:24:031 | varchar(255) | YES | | NULL | |
| 2018/6/5 19:24:02 | varchar(255) | YES | | NULL | |
| 2018/6/5 19:24:032 | varchar(255) | YES | | NULL | |
+--------------------------------------+--------------+------+-----+---------+-------+
18 rows in set