向MySql5.7添加100W条数据，添加完成后报错，求教是什么原因导致的和如何解决

Question

在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

请问到底是什么原因导致的？如何解决？

Answer 1

你的语句报错了啊，看看你的查询语句