Creating db in MySQL

We would be creating a database (Schema) with name “DEALS” To create a new database, you need to execute below command.

 
CREATE DATABASE DEALS;

To select the database, you have to use below command.

 
USE DEALS;

To create and select the database in a single command, you can use below syntax.

 
CREATE DATABASE DEALS;USE DEALS;

To delete the database, you have to use below command.

 
DROP DATABASE IF EXISTS DEALS;

There is no easy command to rename the database. Also depending upon the MySQL engine you are using, renaming process varies.