Database Manage in MySQL

MySQL Best Practices

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`;

Leave a Reply

Your email address will not be published. Required fields are marked *