mysql 存储过程小例子

DELIMITER // drop procedure fp; // CREATE PROCEDURE fp(IN fid INT) COMMENT '队伍或联盟解散 时， 删除相关的跟帖，主贴，论坛' BEGIN DECLARE a,b INT; DECLARE cur_1 CURSOR FOR SELECT id FROM post WHERE forumId=fid; DECLARE CONTINUE HANDLER FOR NOT FOUND SET b = 1; OPEN cur_1; REPEAT FETCH cur_1 INTO a; DELETE FROM post WHERE threadId=a; DELETE FROM post WHERE id=a; /*SELECT * FROM post WHERE threadId=a;*/ /*SELECT * FROM post WHERE id=a;*/ UNTIL b = 1 END REPEAT; CLOSE cur_1; DELETE FROM forum WHERE id=fid; /*SELECT * FROM forum where id=fid;*/ END;// call fp(12);//