DELIMITER $$
DROP PROCEDURE IF EXISTS `tempdb`.`test`$$
CREATE DEFINER=`jx`@`%` PROCEDURE `test`(table_date varchar(20))
BEGIN
set @DYNCSQL = CONCAT('rename table d_referrer_201208 to d_referrer_',table_date);
prepare stmt1 from @DYNCSQL;
execute stmt1;
END$$
DELIMITER ;
Mysql 动态SQL 应用
最新推荐文章于 2022-07-19 18:12:59 发布