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 DATABSE  demo_database;