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
ÊÇµÈ¼ÛµÄ ¡£