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.
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`;
Very few brands suffer from a product issue. It's a conversion issue. People enter DMart,…
The onboarding process of the retailer, distributor, or partner may soon become problematic if there…
Many of the states in the United States of America allow the use of medical…
Did you know that every time you browse this website or any other, you leave…
Online casino has gained immense popularity with the rise of online casinos. Platforms like GameZone…
Every business has one or several peak seasons or periods of time during the year…