Database Manage in MySQL is a first priority to maintain a database. Here you will learn how you can manage database i.e. create a new database in MySQL, remove existing database etc.
A database is nothing but a container of data that stores any kind of data.
Here is how database manage:
Creating Database
CREATE DATABASE [IF NOT EXISTS] `my_db`;
Suppose you don’t know whether database exists or not and you want to create a database. On that case IF NOT EXISTS clause prevents you from an error while creating a new database that already exists previously.
Displaying all Databases
The SHOW DATABASES statement displays all the databases present in the MySQL database server.
Read Also: MySQL Best Practices
SHOW DATABASES;
USE a database to work with
Before query to the database you need to select the database.
USE `my_db`;
Remove Databases
Want to delete the database and all its data physically?
Use below query:
DROP DATABASE [IF EXISTS] `my_db`;
For any types of queries, you can contact us on info[at]namasteui.com.