交换两个表

>create table tbl1(
tbl1_id int
);

>create table tbl2(
tbl2_id int
);

>desc tbl1;
>desc tbl2;

>rename table tbl1 to tbl3, tbl2 to tbl1, tbl3 to tbl2;

>desc tbl1;
>desc tbl2;

posted @ 2013-08-22 08:19  waldmer  阅读(144)  评论(0编辑  收藏  举报