发布时间:2020-10-31 20:10:26
今天用group by进行查询时遇到的报错ERROR 1055 (42000): Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column '***' which is not functionally dependent on columns in GROUP BY clause; this is incompatible withsql_mode=only_full_group_by这是高版本的默认设置导致的。.........【阅读全文】