Shulou(Shulou.com)05/31 Report--

MySQL how to switch tables in stored procedures, this article introduces the corresponding analysis and solutions in detail, hoping to help more partners who want to solve this problem to find a more simple and easy way.

DELIMITER $$DROP PROCEDURE IF EXISTS `sp_revoke_ Table` $$CREATE DEFINER= `root` @ `% `PROCEDURE `root` (p_table_name VARCHAR) BEGIN SET @ t_tb_src = proomtabletablename; SELECT CONCAT ("create table_ tmpdba like", @ t_tb_src) INTO @ t_sql FROM DUAL; PREPARE stmt_1 FROM @ troomsql; EXECUTE stmt_1; DEALLOCATE PREPARE stmt_1 SELECT CONCAT ("_", @ t_tb_src, "_", DATE_FORMAT (NOW (),'% Y% m% dice% 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 @ tactisql; EXECUTE stmt_2; DEALLOCATE PREPARE stmt_2; END$$DELIMITER; this is the answer to the question about how MySQL switches tables in stored procedures. I hope the above content can be of some help to you. If you still have a lot of doubts to be solved, you can follow the industry information channel for more related knowledge.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.