mysql sql_mode的问题

z8323664 2018-10-03 07:23:19
提示:

1055 - Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'cobubrazor.d.date_sk' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by, Time: 0.014000s



mysql> show variables like "%sql_mode%";
+---------------+------------------------------------------------------------------------------------------------------------------------+
| Variable_name | Value |
+---------------+------------------------------------------------------------------------------------------------------------------------+
| sql_mode | STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION |
+---------------+------------------------------------------------------------------------------------------------------------------------+
1 row in set (0.01 sec)

mysql>



这是为啥?第一个是存储过程, 难道没用吗?
...全文
340 点赞 收藏 3
写回复
3 条回复
z8323664 2018年10月04日
问题已经解决, 来个接分的
回复 点赞
ACMAIN_CHM 2018年10月04日
回复 点赞
z8323664 2018年10月03日
mysql版本是5.7.23, 为什么都没有only_full_group_by却还提示呢
回复 点赞
发动态
发帖子
MySQL
创建于2007-09-28

2.4w+

社区成员

5.5w+

社区内容

MySQL相关内容讨论专区
社区公告
暂无公告