系统配置

解决Mysql的only_full_group_by报错

微信扫一扫,分享到朋友圈

解决Mysql的only_full_group_by报错
收藏 0 0

报错内容

[Err] 1055 - Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column 'information_schema.PROFILING.SEQ' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by

第一种解决方案:SQL脚本

SET sql_mode=(SELECT REPLACE(@@sql_mode,'ONLY_FULL_GROUP_BY',''));

第二种解决方案:配置文件

my.ini中sql_mode去掉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' 
锦城虽云乐,不如早还家。
下一篇

Elasticsearch 2050授权操作方法

你也可能喜欢

发表评论

您的电子邮件地址不会被公开。 必填项已用 * 标注

提示:点击验证后方可评论!

插入图片