Creating Databases
The CREATE DATABASE statement can create a new, empty database without any tables or data. The following statement creates a database called winestore:
mysql> CREATE DATABASE winestore;
To work with a database, the command interpreter requires the user to be using a database before SQL statements can be issued. Different command interpreters have different methods for using a database and these aren't part of the SQL standard. In the MySQL interpreter, you can issue the command:
mysql> use winestore
For the rest of this chapter, we omit the mysql> prompt from the command examples.