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;
Comments