| « | August 2025 | » | | 日 | 一 | 二 | 三 | 四 | 五 | 六 | | | | | | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31 | | | | | | | |
|
公告 |
戒除浮躁，读好书，交益友 |
| Blog信息 |
|
blog名称:邢红瑞的blog
日志总数:523
评论数量:1142
留言数量:0
访问次数:9701403
建立时间:2004年12月20日 |
| |
|
 [数据库]SELECT INTO + SUBQUERY WITH UNION mysql的bug
原创空间, 文章收藏, 网上资源, 软件技术, 电脑与网络
邢红瑞 发表于 2008/9/17 9:50:17 |
| 一般真还是 遇不到这个问题，写一个存储过程，统计最近n天的数据。参数 IN nday INT ,OUT n_count INTBEGINSELECT SUM(rowcount) into @n_count from (select count(*) as rowcount from user01 WHERE createtime >= DATE_SUB(CURDATE(), INTERVAL nday+1 DAY ) AND createtime < DATE_SUB(CURDATE(), INTERVAL nday DAY ) union select count(*) as rowcount from user02 WHERE createtime >= DATE_SUB(CURDATE(), INTERVAL 1 DAY ) AND createtime < CURDATE() ) as tmp;
END出现 ERROR 1221 (HY000): Incorrect usage of UNION and INTO。认为是sql语句写错了。写个sql，select SUM(a) FROM (select 1 AS a UNION SELECT 2 AS a) AS b;正常select SUM(a) INTO @b FROM (select 1 AS a UNION SELECT 2 AS a) AS b;出错。看了一下，是mysql 33096 bug，5.0.45-log 以后出现的。以前的版本 ，没有问题。 |
|
|