Mysql 5.7.9 插入or更新时报错记录

  • 2017-12-26
  • 76
  • 0
  • 0

错误信息:

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',''));

问题解决!

评论

还没有任何评论,你来说两句吧

发表评论