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. |