mysql 存储过程 传表名

[rgbaflf]

DELIMITER $$

USE `portal`$$

DROP PROCEDURE IF EXISTS `clear_wrong_data`$$

CREATE DEFINER=`root`@`localhost` PROCEDURE `clear_wrong_data`()
BEGIN
DECLARE done INT DEFAULT 0;
DECLARE v_id INT;
DECLARE v_id_count INT;
DECLARE cur CURSOR FOR SELECT task_id FROM table_risk;
DECLARE CONTINUE HANDLER FOR NOT FOUND SET done =1;
OPEN cur;
REPEAT
FETCH cur INTO v_id;
IF NOT done THEN
SELECT COUNT(*) INTO v_id_count FROM table_task WHERE id = v_id;
IF v_id_count=0 THEN
DELETE FROM table_risk WHERE task_id = v_id;
COMMIT;
END IF;
END IF;
UNTIL done END REPEAT;
CLOSE cur;
END$$


存储过程如上所示，我现在希望 table_risk,table_task,task_id,id 作为参数传进去，应该怎么改啊？

[花谢尊前不敢香]

CREATE DEFINER=`root`@`localhost` PROCEDURE `clear_wrong_data`() @table_risk varchar(50) BEGIN ... DECLARE cur CURSOR FOR SELECT task_id FROM "+@table_risk+";//类似于这样不行吗？

[rgbaflf]

引用 1 楼 fangmingshijie 的回复:

CREATE DEFINER=`root`@`localhost` PROCEDURE `clear_wrong_data`() @table_risk varchar(50) BEGIN ... DECLARE cur CURSOR FOR SELECT task_id FROM "+@table_risk+";//类似于这样不行吗？

不可以哦