mariadb root@localhost: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.059s
mariadb root@localhost:dyw> show tables; +---------------+ | Tables_in_dyw | +---------------+ | atbl | | dcount | +---------------+ 2 rows in set Time: 0.024s
mariadb root@localhost: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.080s
mariadb root@localhost:dyw> show tables; +---------------+ | Tables_in_dyw | +---------------+ | dcount | | tbl | +---------------+ 2 rows in set Time: 0.020s