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.