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;
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;