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)