DELIMITER $$ CREATE
/*[DEFINER = { user | CURRENT_USER }]*/
PROCEDURE `gdims`.`PRO_EMERGENCY_COUNT_YEAR`(
town int, -- 镇乡 -1为全部
place int -- 片所 -1为全部
)
BEGIN
DECLARE parm1 int;
set @parm1 = 2000;
CREATE TABLE MyTempTable (_year int);
while (parm1<=year(GETDATE()))
insert into MyTempTable values (parm1);
set @parm1 = parm1+1;
end while;
END$$
select t1.*,
t_num= case when t2.num is null then 0
else num end
from MyTempTable t1 left join (
select year(tisd_happen_time) as t_year,count(is_add) as num from tisd_quickly
where (tisd_town =town or -1=town) and (place_name=place or -1=place)
group by year(tisd_happen_time)
) t2 on t1._year = t2.t_year -- 将临时表和 按年分类统计的表格进行左关联 达到期望的要求
DELIMITER ;
-------------------------------------------------------------------------------------------
语法错误,怎么改,有人知道没?
Error Code : 1064
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'insert into MyTempTable values (parm1)
set @parm1 = parm1+1
end w' at line 13
(0 ms taken)
/*[DEFINER = { user | CURRENT_USER }]*/
PROCEDURE `gdims`.`PRO_EMERGENCY_COUNT_YEAR`(
town int, -- 镇乡 -1为全部
place int -- 片所 -1为全部
)
BEGIN
DECLARE parm1 int;
set @parm1 = 2000;
CREATE TABLE MyTempTable (_year int);
while (parm1<=year(GETDATE()))
insert into MyTempTable values (parm1);
set @parm1 = parm1+1;
end while;
END$$
select t1.*,
t_num= case when t2.num is null then 0
else num end
from MyTempTable t1 left join (
select year(tisd_happen_time) as t_year,count(is_add) as num from tisd_quickly
where (tisd_town =town or -1=town) and (place_name=place or -1=place)
group by year(tisd_happen_time)
) t2 on t1._year = t2.t_year -- 将临时表和 按年分类统计的表格进行左关联 达到期望的要求
DELIMITER ;
-------------------------------------------------------------------------------------------
语法错误,怎么改,有人知道没?
Error Code : 1064
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'insert into MyTempTable values (parm1)
set @parm1 = parm1+1
end w' at line 13
(0 ms taken)
解决方案 »
- PostgreSQL如何指定默认的Schema---100分在线等~!小问题!~
- mysql 还原数据库问题(MS很偏的问题)
- 求一sql语句!!!在线等 分不够可加!
- vb 不能向mysql 插入中文数据
- MySQL中,DatabaseMetaData.getTables方法返回的ResultSet中的第二个字段均为空,是否一定是这样的?
- 放分100,sqlyog图像建表,报错,语句建表也报错。。。。。。。。。。。。。。。。。。。。。。。。。。。。
- =========關于MySql的用戶問題============
- 一个月内分时间段查询数据的和
- bat操作mysql,出错之后如何记录日志
- mysql 启动错误 1067
- 询问关于discuz数据库设计的问题,为什么它的时间不用timestamp而是int,是非的值也不用boolean而是tinyint(1)
- 简单的update语句
'截至2011-04-11 16:08:09 用户结帖率0.00% 当您的问题得到解答后请及时结贴.
http://topic.csdn.net/u/20090501/15/7548d251-aec2-4975-a9bf-ca09a5551ba5.html
http://topic.csdn.net/u/20100428/09/BC9E0908-F250-42A6-8765-B50A82FE186A.html
http://topic.csdn.net/u/20100626/09/f35a4763-4b59-49c3-8061-d48fdbc29561.html8、如何给分和结贴?
http://community.csdn.net/Help/HelpCenter.htm#结帖