Let’s examine the CREATE DATABASE statement in greater detail:
Followed by the CREATE DATABASE statement is database name that you want to create. It is recommended that the database name should be as meaningful and descriptive as possible.
The IF NOT EXISTS is an optional clause of the statement. The IF NOT EXISTS clause prevents you from an error of creating a new database that already exists in the database server. You cannot have 2 databases with the same name in a MySQL database server.
For example, to create classicmodels database, you can execute the CREATE DATABASE statement as follows: