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

You may also like...