What is 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:

DROP DATABASE database_name;  

Example:

Let's take an example to drop a database name "employees"

DROP DATABASE employees;  

It will look like this:

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

SHOW DATABASES;  

Output:

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.

 

Next Post Previous Post
No Comment
Add Comment
comment url