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.