本人微信公众号"aeolian"~

mysql5.7执行sql语句出现only_full_group_by错误

在/etc/my.cnf的[mysqld]组中添加

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

《mysql5.7执行sql语句出现only_full_group_by错误》

《mysql5.7执行sql语句出现only_full_group_by错误》

重启服务

service mysqld stop

service mysqld start

 

点赞

Leave a Reply

Your email address will not be published. Required fields are marked *