which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mod
引用:https://blog.csdn.net/weixin_43064185/article/details/99646535
1查询
SELECT @@sql_mode;
ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION
2删除 ONLY_FULL_GROUP_BY
SET
转载
2020-11-26 11:38:29 ·
232 阅读 ·
0 评论