1、备份表
create table special_machines2 as select * from special_machines;
2、删除表
DROP TABLE special_machines;
3、复制表数据,表结构一样
insert into special_machines select * from special_machines2;
1、备份表
create table special_machines2 as select * from special_machines;
2、删除表
DROP TABLE special_machines;
3、复制表数据,表结构一样
insert into special_machines select * from special_machines2;