2021年1月22日
In aggregated query without GROUP BY, expression #1 of SELECT list contains nonaggregated column 'score.s_id'; this is incompatible with sql_mode=only_full_group_by
摘要： 拿 employee 示例数据库为例，当进行如下操作时会报错。 mysql> SELECT * FROM employees GROUP BY gender; ERROR 1055 (42000): Expression #1 of SELECT list is not in GROUP BY cl 阅读全文
posted @ 2021-01-22 13:52 倨傲君 阅读(894) 评论(0) 推荐(0)