[Err] 1055 - Expression #1 of ORDER BY clause is not in GROUP BY clause 解决办法 MySQL

解决办法:

执行sql 语句:

select version(),
@@sql_mode;SET sql_mode=(SELECT REPLACE(@@sql_mode,'ONLY_FULL_GROUP_BY',''));
posted @ 2020-06-15 18:11  Q1Zhen  阅读(211)  评论(0编辑  收藏  举报