DELIMITER $$
DROP PROCEDURE IF EXISTS `proc`$$
CREATE
PROCEDURE `ondutystatisticdb`.`proc`(tablename VARCHAR(50))
BEGIN
SET @STMT :=CONCAT(" ALTER TABLE ",tablename," DROP PRIMARY KEY;");
PREPARE STMT FROM @STMT;
EXECUTE STMT;
END$$
DELIMITER ;
mysql动态sql,存储过程动态tablename,存储过程参数为表名
最新推荐文章于 2024-07-09 15:22:31 发布