Blog Bustle 11/02/2020
Database can be deleted by mysql query. We should be careful before deleting database because we can lose all information stored in database.
drop database database_name;
This is delete database mysql query to drop database in mysql server.
For example, we are going to delete test_db database and query will be
combined syntax of delete database mysql query with if database exists
DROP DATABASE IF EXISTS database_name;
You can also delete database in mysql by command line.
We create database to store information. Mysql uses Apache web server. Apache http server is free open source web server software.
We create tables inside our database to store information and We use sql to write query in Mysql server.
Our all important information is stored in database so before deleting database we should have our database backup.
If we do not have database backup and we have deleted database then we will not be able to get our database information so be careful before deleting database. We can lose our all information which is stored in database.
Before running delete database mysql query, we should also check that database exists or not in mysql server which is going to be deleted. How can we check it? we have to run show databases like 'database_name'; command.