Creating and Deleting Databases

Creating a Database

The CREATE statement is used to create a database in MySQL. The following statement creates a database called search.

mysql> CREATE DATABASE search;

To let MySQL know that you want to use that database, you use the USE statement. The following example uses the database, search.

mysql> USE search;

Deleting a Database

Databases can be deleted using the DROP statement. The following example deletes the database, search.

mysql> DROP DATABASE search;