Creating database 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.
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.