mysql存储过程的两条语句,其中iIP ,iUV ,iPV 是变量,当我执行时出现这个错误Incorrect usage of UNION and INTO,请问帅哥们怎么解决啊,谢谢。SELECT COUNT(DISTINCT vistor_ip) INTO iIP FROM temp_main_logs_ex1 WHERE web_id=WebId AND login_date=loginDate AND visitor_url=VisitorUrl UNION
SELECT COUNT(VALUE) INTO iUV FROM temp_table1 UNION
SELECT COUNT(log_id) INTO iPV FROM temp_main_logs_ex1 a,temp_table1 b FORCE INDEX (temp_table1_value) WHERE web_id=WebId AND a.session_id=b.value AND login_date=loginDate;
SELECT COUNT(VALUE) INTO iUV FROM temp_table1 UNION
SELECT COUNT(log_id) INTO iPV FROM temp_main_logs_ex1 a,temp_table1 b FORCE INDEX (temp_table1_value) WHERE web_id=WebId AND a.session_id=b.value AND login_date=loginDate;
解决方案 »
- 有关数据库的问题,憋了很久了,求大神指导啊
- 事关SQL执行时间,相当重要,求解释
- mysql 查询问题
- 加单引号值(数值型,文字型,日期型)与不加单引号的值的区别是什么??
- mysql查表问题
- 菜鸟求教:本人2000机子刚装mysql,无法启动,请教如何解决,谢谢。
- 急问:mysql同一张表的左外关联,表别名怎么写???在线等
- 如何计算两个datetime的间隔值单位仍为为datetime
- 在win2000上用java连局域网内linux上的mysql 总是出现错误请高手指点程序如下
- mysql在DOS窗口的进入问题
- postgreSQL ERROR: missing FROM-clause entry for table "glxt320" at character 104
- asp mysql 5.19 odbc 关于asp连接数据库问题。
SELECT SUM(IF(bz=1,1,0)),SUM(IF(bz=2,1,0)),
SUM(IF(bz=3,1,0))
INTO iIP,iUV,iPV FROM (
SELECT DISTINCT 1 AS bz ,vistor_ip FROM temp_main_logs_ex1 WHERE web_id=WebId AND login_date=loginDate AND visitor_url=VisitorUrl UNION
SELECT 2,VALUE FROM temp_table1 UNION
SELECT 3,log_id FROM temp_main_logs_ex1 a,temp_table1 b FORCE INDEX (temp_table1_value) WHERE web_id=WebId AND a.session_id=b.value AND login_date=loginDate) a;
from (
SELECT COUNT(DISTINCT vistor_ip) as v1
FROM temp_main_logs_ex1
WHERE web_id=WebId AND login_date=loginDate AND visitor_url=VisitorUrl
) a, (
SELECT COUNT(VALUE) as v2 FROM temp_table1
) b, (
SELECT COUNT(log_id) as v3 FROM temp_main_logs_ex1 a,temp_table1 b FORCE INDEX (temp_table1_value)
WHERE web_id=WebId AND a.session_id=b.value AND login_date=loginDate
) c ;