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;
解决方案 »
- 一个让人百思不得其解的结果
- mysql不能正常显示中文 已设置为utf8
- ERROR 1146 (42S02): Table 'XXX.XXX' doesn't exist
- 设置wait_timeout = 10后,连接的线程不关闭,状态sleep.不解!!
- 高分求一条最优的sql语句
- 急:在线等,不小心drop了表,怎么办,没备份?有机会恢复没???
- mysql里有没有DateDiff()函数?
- 求一条查询语句,列名:test(varchar).我想查找列出符合该字段中所有包含"good"的子串;
- 一个有关数据库存储字节(byte)的问题
- 请问哪位在实际环境中用过OceanBase
- 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 ;