PHP Create and Drop a DB

The first step you need to use a database is… to create one.

The SQL syntax to create a database is quite simple:

CREATE DATABASE `examples` ;

1	CREATE DATABASE `examples` ;

As a good practice we will write SQL commands and keywords in uppercase. Please note that the use of SQL angle quotations (`) is optional.

The SQL command to delete a database is drop:

DROP DATABASE `examples`;

1	DROP DATABASE `examples`;