mysql 5.7.9在delete30万数据时时报错

mysql在执行: "delete from test_table;"时报错："1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column 'informat.."
其中test_table中大约有30万的测试数据;
解决方法：
修改/etc/my.cnf,添加如下内容

sql_mode=STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION
set sql_mode = 'NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES';

参考网址：
https://blog.csdn.net/HaHa_Sir/article/details/80503601
https://blog.csdn.net/qq37350706/article/details/81707862