MySQL Drop Database

You can drop/delete/remove a MySQL database easily with the MySQL command. You should be careful while deleting any database because you will lose your all the data available in your database.

Syntax:

  1. DROP DATABASE database_name;

Example:

Let’s take an example to drop a database name “employees”

  1. DROP DATABASE employees;

It will look like this:

mysql drop database 1

Now you can check that either your database is removed by executing the following query:

  1. SHOW DATABASES;

Output:

mysql drop database 2

Here, you can see that the database “employees” is removed.

Spread the love

One comment

Leave a Reply

Your email address will not be published. Required fields are marked *