mysql 5.7 this is incompatible with sql_mode=only_full_group_by
vi /etc/my.cnf
#在配置文件最后一行加上下面内容
sql_mode=STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION
原创
2020-06-29 17:16:22 ·
272 阅读 ·
0 评论