ERROR 1055 (42000): Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregate
摘要:
字面意思理解是sql_model=only_full_group_by限制了,导致在以往MYSQL版本中能正常查询的SQL,在5.7不能用了参考文档:http://dev.mysql.com/doc/refman/5.7/en/sql-mode.html#sql-mode-setting 文档指出: 阅读全文