RENAME 重新命名

1. ALTER RENAME TO 變更資料表 tbl 名稱為 atbl。

   MariaDB root@(none):dyw> alter table tbl rename atbl;
   You're about to run a destructive command.
   Do you want to proceed? (y/n): y
   Your call!
   Query OK, 0 rows affected
   Time: 0.036s
   

2. 再查看資料表。

   MariaDB root@(none):dyw> show tables;
   +---------------+
   | Tables_in_dyw |
   +---------------+
   | atbl          |
   | dcount        |
   +---------------+
   
   2 rows in set
   Time: 0.021s
   

3. ALTER RENAME TO 再將資料表 atbl 名稱變更回 tbl。

   MariaDB root@(none):dyw> alter table atbl rename tbl;
   You're about to run a destructive command.
   Do you want to proceed? (y/n): y
   Your call!
   Query OK, 0 rows affected
   Time: 0.019s
   

4. 再查看資料表。

   MariaDB root@(none):dyw> show tables;
   +---------------+
   | Tables_in_dyw |
   +---------------+
   | dcount        |
   | tbl           |
   +---------------+
   
   2 rows in set
   Time: 0.019s