Cheap VPS & Xen Server


Residential Proxy Network - Hourly & Monthly Packages

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:

mysqldropdatabase

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

  1. SHOW DATABASES;

Output:

mysqldropdatabase2

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

Note: All the database names, table names and table fields name are case sensitive. You must have to use proper names while giving any SQL command.

Comments

comments