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

在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

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

查看回复