2018年10月12日
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
摘要： 解决方法一： SET sql_mode=(SELECT REPLACE(@@sql_mode,'ONLY_FULL_GROUP_BY','')); 优点：不用重启mysql 缺点：重启mysql后还会出现标题错误 SELECT @@global.sql_mode; 查询全局的 @@session.s 阅读全文
posted @ 2018-10-12 11:31 苍洱 阅读(4194) 评论(0) 推荐(0) 编辑