CREATE TABLE IF NOT EXISTS new_table_bak (LIKE old_table);
INSERT INTO new_table_bak SELECT * FROM old_table;
2.Create table new_table_name (Select * from old_table_name);
CREATE TABLE IF NOT EXISTS new_table_bak (LIKE old_table);
INSERT INTO new_table_bak SELECT * FROM old_table;
2.Create table new_table_name (Select * from old_table_name);