MySQL Drop Database

RSS
EMAIL
FACEBOOK
FACEBOOK
GOOGLE
GOOGLE
https://www.poftut.com/mysql-drop-database/
PINTEREST
PINTEREST
INSTAGRAM

MySQL is very popular opensource database it is used by a lot of different type and size companies. In this post we will look how to drop or delete MySQL databases?

Drop Database

Dropping/Deleting/Removing a database in MySQL server is simple and fast solution which will delete data as well as table and database schemes. We will command to the local MySQL server daemon whit root privileges.

We will list existing databases to get database name and do not make mistake.

We will drop database names test. Syntax of drop is simple like below. We issue command DROP DATABASE and provide database name as in this example test.

Drop All Tables In A Database

Another alternative is dropping all tables one by one or with a simple script. Here database will be not removed but the tables of the database will be deleted.

RSS
EMAIL
FACEBOOK
FACEBOOK
GOOGLE
GOOGLE
https://www.poftut.com/mysql-drop-database/
PINTEREST
PINTEREST
INSTAGRAM

Leave a Reply

Your email address will not be published.

Enjoy this blog? Please spread the word :)