- 摘要:[Err]1055-Expression#1ofORDERBYclauseisnotinGROUPBYclauseandcontainsnonaggregatedcolumn'information_schema.PROFILING.SEQ'whichisnotfunctionallydependentoncolumnsinGROUPBYclause;thisisincompatiblewithsql_mode=only_full_group_by不知道为何,在用nivaca
-
[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
不知道为何,在用nivacat_mysql时,每次允许sql语句时都提示这个问题。
网上说什么my.cnf文件里修改sql_mode,把only_full_group_by去掉。
但是没有解决问题,因为我没有找到my.cnf。
后来找到了方法,解决问题了。
如下:
第一行是查看sql_mode。
第二行是修改。
- 以上是[Err] 1055 - Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated..的内容,更多clause nonaggregated expression contains group order 1055 err 的内容,请您使用右上方搜索功能获取相关信息。
[Err] 1055 - Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated..
最新推荐文章于 2024-07-31 19:32:37 发布