SQL DROP TABLE 簡單使用
本次環境使用的是MySQL5.7版 1. 根據表名稱刪除表 DROP TABLE tableName mysql> show tables; +-------------------+ | Tables_in_test | +-------------------+ | Persons | | Persons_copy | | Persons_copy_copy | +-------------------+ 3 rows in set (0.00 sec) mysql> DROP TABLE Persons_copy_copy; Query OK, 0 rows affected (0.11 sec) mysql> show tables; +----------------+ | Tables_in_test | +----------------+ | Persons | | Persons_copy | +----------------+ 2 rows in set (0.00 sec)