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;

posted @ 2017-06-06 16:06  lq_cnblogs  阅读(309)  评论(0编辑  收藏  举报