Mysql 5.7 表名大小写、ONLY_FULL_GROUP_BY和中文UTF-8的设置问题

Posted by 浮生 on 03-11,2020

表名大小写敏感

lower_case_table_names=1

ONLY_FULL_GROUP_BY 问题

sql_mode='STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION'

中文和UTF-8设置

[mysqld]
character_set_server=utf8

[client]
default-character-set=utf8

以上设置都在配置文件里面修改