在centos6.5上装好mysql5.7,建了一张user表,引擎用的是myIsam,使用存储过程循环插入100W数据,完成后,报出如下错误:
受影响的行: 0
时间: 144.871s
[Err] 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; this is incompatible with sql_mode=only_full_group_by
请问到底是什么原因导致的?如何解决?
你的语句报错了啊,看看你的查询语句