[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…
解决方法:运行以下语句
select version(),
@@sql_mode;SET sql_mode=(SELECT REPLACE(@@sql_mode,‘ONLY_FULL_GROUP_BY’,’’));
新增永久解决办法:两篇一起看
已知会遇到mysql服务不会自动启动的bug。待解决
https://blog.csdn.net/weixin_39956356/article/details/85533742
https://blog.csdn.net/Luoposhan_master?spm=1000.2115.3001.5113