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;
转载于:https://www.cnblogs.com/lqCnblog/p/6952086.html