You can use the DROP DATABASE statement to delete a database.
drop_database_stmt: DROP DATABASE [IF EXISTS] database_name;
|IF EXISTS||This parameter is used to mitigate errors that occur when you delete a database that does not exist.|
|database_name||The name of the database that you want to delete.|
Use the following statements to delete a database that is named test:
drop database test; Query OK, 0 rows affected (0.03 sec) drop database if exists test; Query OK, 0 rows affected, 1 warning (0.00 sec)