MySQL swap table names for 2 sheets

In MySQL, how to complete the swap of 2 tables, such as T1 and T2 table name Swap, really just mutual rename so simple?

Note that we want to complete 2 tables at the same time, otherwise it will cause data write failure, so we need to lock the table before switching, while locking 2 tables, and then modify the name of the table:

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;

This will be OK.

More wonderful MySQL Learning resources, in my win the workplace!

http://www.wyzc.com/mysql/?tg=LXUK--Zkf&tg=3006123630

MySQL swap table names for 2 sheets