MySQL CREATE AND DROP DATABASE

CREATE DATABASE 

The CREATE DATABASE statement is used to create a new database. 

SYNTAX:

create database database_name;

EXAMPLE:

The following SQL statement creates a database called "demo_database":

create database demo_database;

DROP DATABASE

The DROP DATABASE Statement is used to delete a existing data base. 

SYNTAX:

drop database database_name;

EXAMPLE:

The following SQL statement creates a database called "demo_database":

drop database demo_database;