Expression #1 of ORDER BY clause is not in SELECT list, references column ‘d.dept_no‘ which is not i
问题:添加distinct报错原因:mysql5.7.5及以上版本将sql_mode的ONLY_FULL_GROUP_BY模式默认设置为打开状态时,导致:使用order by的时候不能用distinct解决:set global sql_mode='STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION';该.
原创
2022-02-09 19:35:40 ·
1550 阅读 ·
0 评论