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
我在数据库进行迁移创建的时候遇到了这个问题，我数据表是用navicate来创建的，只需要再在编辑查询里面加上下面这句话，再运行就好了
解决办法：
'''
select version(),
@@sql_mode;SET sql_mode=(SELECT REPLACE(@@sql_mode,'ONLY_FULL_GROUP_BY',''));
'''
1055 - Expression #1 of ORDER BY clause is not in GROUP B...
安装好数据库进行操作时，报 [Err] 1055 - Expression #1 of ORDER BY clau...
解决mysql出现的问题#1055 - Expression of SELECT list is not in G...
[Err] 1055 - Expression #1 of ORDER BY clause is not in G...
[Err] 1055 - Expression #1 of ORDER BY clause is not in G...
[Err] 1055 – Expression #1 of ORDER BY clause is not in G...
1055 - Expression #1 of SELECT list is not in GROUP BY cl...
[Err] 1055 - Expression #1 of ORDER BY clause is not in G...
MYSQL版本比较新，有好几个错误问题 [Err] 1055 - Expression #1 of ORDER B...
ERROR 1055 (42000): Expression #1 of SELECT list is not i...
本文标题：数据库创建遇到的问题：1055 - Expression #1
本文链接：https://www.haomeiwen.com/subject/qucmeqtx.html
网友评论