解决 Cause: java.sql.SQLSyntaxErrorException: Expression #1 of SELECT list is not in GROUP BY错误
数据库之前的版本是5.6,更换数据库到8.0之后,突然之前的sql执行报错。[Err] 1055 - Expression #1 of ORDER BY clause is not in GROUP BYclause and contains nonaggregated column'information_schema.PROFILING.SEQ' which is not functionally dependenton columns in GROUP BY clause; this is i
原创
2021-01-08 13:38:54 ·
15761 阅读 ·
3 评论