MySQL 存储过程进行切换表

最新推荐文章于 2024-10-06 20:16:20 发布

CRMEB定制开发

最新推荐文章于 2024-10-06 20:16:20 发布

阅读量198

点赞数

文章标签： java mysql python 数据库 linux

本文链接：https://blog.csdn.net/qq_39221436/article/details/117286377

版权

DELIMITER $DROP PROCEDURE IF EXISTS `sp_revoke_table`$
CREATE DEFINER=root@% PROCEDURE sp_revoke_table(p_table_name VARCHAR(100))
BEGIN
SET @t_tb_src = p_table_name;
SELECT CONCAT("create table _tmpdba like ", @t_tb_src) INTO @t_sql FROM DUAL;
PREPARE stmt_1 FROM @t_sql;
EXECUTE stmt_1;
DEALLOCATE PREPARE stmt_1;

SELECT CONCAT("_", @t_tb_src, "_",  DATE_FORMAT(NOW(),'%Y%m%d_%H%i%s'), "_del") INTO @t_table_today FROM DUAL;
SELECT CONCAT("rename table ", @t_tb_src, " TO ",@t_table_today, ", _tmpdba to ", @t_tb_src ) INTO @t_sql FROM DUAL;
PREPARE stmt_2 FROM @t_sql;
EXECUTE  stmt_2;
DEALLOCATE PREPARE stmt_2;
 
END$$

DELIMITER ;

完整实例：http://github.crmeb.net/u/defu

来自 “开源世界 ” ，链接：http://ym.baisou.ltd/post/620.html，如需转载，请注明出处，否则将追究法律责任。