mysql t1表和t2表,表名互换,数据量大时应慎重考虑
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;
mysql t1表和t2表,表名互换,数据量大时应慎重考虑
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;