mysql存储过程 赋值

IN expireDate VARCHAR(20),IN resType INT
//-----------------------------------------------------------------------------------
BEGIN
DECLARE a,b,icon_id INT;
DECLARE cur_1 CURSOR FOR SELECT id from `tbl_resource` WHERE discriminator="RC_CON"  and robot_type=resType and  add_date<=expireDate;/*robot_type 代替资源类型*/
DECLARE CONTINUE HANDLER FOR NOT FOUND
SET b = 1;
OPEN cur_1;
REPEAT
FETCH cur_1 INTO a;
SELECT smallIcon INTO icon_id  from  tbl_resource WHERE id=a;     /*得到缩略图片的id*/
DELETE from `tbl_resource` WHERE parent_id=a;                /*删除这个content所含的资源*/
DELETE from `tbl_visitrecords` WHERE resource_id=a;        /*删除访问信息*/
DELETE from `tbl_detailrecord` WHERE resource_id=a;       /*删城祥细访问信息 */
DELETE from `tbl_comment` WHERE resource_id=a;           /*删城相关评论*/
DELETE from `tbl_resource` WHERE id=a;                          /*删城自己*/
IF icon_id >0 THEN
 DELETE from `tbl_resource` WHERE id=icon_id;       /*删除图标*/
 /*SELECT "删除了"+icon_id;*/
END IF;
UNTIL b = 1
END REPEAT;
CLOSE cur_1;
/*SELECT count(id) from `tbl_resource` WHERE discriminator="RC_CON"  and robot_type=0 and  add_date<=expireDate;*/
END
//相关语法
if Null is Null then
SELECT 23;
else
SELECT 45; 
end IF;
//赋值
select @cnt := count(1) from tablenmae
和
select count(1) into @cnt from tablename
是等价的 。