[Err] 1055 - Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated c
使用了方案:
只修改当前数据库的SQL_MODE
#查询
SELECT @@sql_mode;
#修改
SET sql_mode=(SELECT REPLACE(@@sql_mode,'ONLY_FULL_GROUP_BY',''));
再次插入不再报错。
[Err] 1055 - Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated c
使用了方案:
只修改当前数据库的SQL_MODE
#查询
SELECT @@sql_mode;
#修改
SET sql_mode=(SELECT REPLACE(@@sql_mode,'ONLY_FULL_GROUP_BY',''));
再次插入不再报错。