如何将两个表名对调

同时锁定2个表，不允许写入，然后对调表名。

 

LOCK TABLES t1 WRITE, t2 WRITE;

ALTER TABLE t1 RENAME TO t3;

ALTER TABLE t2 RENAME TO t1;

ALTER TABLE t3 RENAME TO t2;

UNLOCK TABLES;