将mysql5.5换成5.7版本之后遇到的问题,在新建表时发生如下错误,在网上看了很多方法得到解决
[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中添加配置,注意是添加在[mysqld]中
sql_mode=STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION
然后重启mysql服务,重启服务的方式有很多种我直接使用的是net stop mysql停止mysql服务,然后使用net start mysql启动mysql服务,注意需要以管理员身份运行命令行
参考博客:https://blog.csdn.net/u012187452/article/details/82120345