MySql教程

mysql5.7执行sql语句成功,但是报错Err:1055

本文主要是介绍mysql5.7执行sql语句成功,但是报错Err:1055,对大家解决编程问题具有一定的参考价值,需要的程序猿们随着小编来一起学习吧!

无论执行什么sql语句都报错:

[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

试了好多方法,最后通过修改my.ini文件彻底解决:

1,运行

SHOW VARIABLES LIKE "sql_mode";

结果:ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION

2,将上述结果的ONLY_FULL_GROUP_BY去掉,赋值到my.ini文件下的[mysqld]下的sql_mode

即:sql_mode=STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SU

 

 重启服务

 

 再次运行,成功!

 

这篇关于mysql5.7执行sql语句成功,但是报错Err:1055的文章就介绍到这儿,希望我们推荐的文章对大家有所帮助,也希望大家多多支持为之网!