null用不用大写mysql_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