mysql 同数据库下删除表,备份数据表及数据,还可以快速恢复表及数据

CREATE TABLE tab1_bak LIKE sys_dictionary_details;
INSERT INTO tab1_bak SELECT * FROM sys_dictionary_details;

DROP TABLE sys_dictionary_details;

ALTER TABLE tab1_bak RENAME sys_dictionary_details;

原文地址:https://www.cnblogs.com/lqCnblog/p/6952086.html