Creating a Database
After design, the first step in creating a database is, logically enough, to tell MySQL that we want to create a new database. We do this with the CREATE DATABASE SQL statement, as follows:
create database employee;
You can check to see that this statement worked by executing the command
show databases;
You should now see the employee database listed among the databases in the system.
We now have an empty database, waiting for some tables to be created.
| 
