mysql异常——[Err] 1055 - Expression #1 of ORDER BY clause is not in GROUP BY clause and

解决方案：

只修改当前数据库的SQL_MODE

-- 查看SQL_MODE
SELECT @@sql_mode;

-- 修改SQL_MODE
SET sql_mode=(SELECT REPLACE(@@sql_mode,'ONLY_FULL_GROUP_BY',''));