DELIMITER $$
DROP PROCEDURE IF EXISTS 'removeforums_pro'$$
CREATE PROCEDURE 'removeforums_pro'(IN fid bigint)
BEGIN
set @stmt=concat('delete form threads t where t.tid=',fid);
prepare stmt from @stmt;
execute stmt;
END$$
DELIMITER ;
DROP PROCEDURE IF EXISTS 'removeforums_pro'$$
CREATE PROCEDURE 'removeforums_pro'(IN fid bigint)
BEGIN
set @stmt=concat('delete form threads t where t.tid=',fid);
prepare stmt from @stmt;
execute stmt;
END$$
DELIMITER ;
CREATE PROCEDURE 'removeforums_pro'(IN fid bigint) --------->DROP PROCEDURE IF EXISTS `removeforums_pro`$$
CREATE PROCEDURE `removeforums_pro`(IN fid bigint)
http://topic.csdn.net/u/20090501/15/7548d251-aec2-4975-a9bf-ca09a5551ba5.html