Dropping a Database
Use the DROP DATABASE command to drop a database completely. Use this command with extreme caution—you cannot recover a dropped database unless you have a backup.
Dropping Databases
| A user must have the DROP privilege in order to drop a database. Grant this privilege sparingly. |
To drop the greekdb database, issue the following command:
mysql> DROP DATABASE greekdb;
Query OK, 0 rows affected (0.00 sec)
Similar to CREATE DATABASE IF NOT EXISTS, you can use DROP DATABASE IF EXISTS to suppress an error if you try to drop a nonexistent database.
Get Sams Teach Yourself MySQL now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
