Cách xóa database MySQL?

Dùng DROP DATABASE TenDatabase;

Danh sách database trước khi xóa

mysql> SHOW DATABASES;

+--------------------+
| Database           |
+--------------------+
| business           |
| database1          |
| databasesample     |
| education          |
| hello              |
| information_schema |
| javadatabase       |
| javadatabase2      |
| ...                |
| test               |
| universitydatabase |
+--------------------+
20 rows in set (0.00 sec)

Xóa javadatabase

mysql> DROP DATABASE javadatabase;
Query OK, 0 rows affected (0.19 sec)

Kiểm tra lại

mysql> SHOW DATABASES;

+--------------------+
| Database           |
+--------------------+
| business           |
| database1          |
| databasesample     |
| education          |
| hello              |
| information_schema |
| javadatabase2      |
| ...                |
| test               |
| universitydatabase |
+--------------------+
19 rows in set (0.00 sec)

Giảm từ 20 xuống 19 database. 'javadatabase' đã bị xóa vĩnh viễn.