mysql-font报错
解决方法
set @@global.sql_mode='STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION';
临时解决，重启电脑后依旧，对新建的数据库这个设置有效，已存在无效
原因：是由于默认的 MySQL 配置中 sql_mode 配置了 only_full_group_by，需要 GROUP BY 中包含所有 在 SELECT 中出现的字段。
set sql_mode ='STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION';
本质上事将配置写到my.ini最后
解决了
错误：Expression #2 of SELECT list is not in GROUP BY clause...
mysql-font报错解决方法 临时解决，重启电脑后依旧，对新建的数据库这个设置有效，已存在无效 原因：是由于默...
maven 项目报错 expression #2 of SELECT list contains nonaggre...
今儿在分类查询时Mysql报错，1055 - Expression #2 of SELECT list is no...
解决mysql出现的问题#1055 - Expression of SELECT list is not in G...
Expression #1 of SELECT list is not in GROUP BY clause an...
Expression #1 of SELECT list is not in GROUP BY clause an...
1055 - Expression #1 of SELECT list is not in GROUP BY cl...
ERROR 1055 (42000): Expression #1 of SELECT list is not i...
mysql遇见Expression #1 of SELECT list is not in GROUP BY cl...
本文标题：Expression #2 of SELECT list is
本文链接：https://www.haomeiwen.com/subject/cqkynctx.html
网友评论