CREATE DATABASE
Use the CREATE DATABASE command to create a new database.
Syntax
CREATE DATABASE [ IF NOT EXISTS ] database_name;
Parameters
| Parameter or clause | Description |
|---|---|
| database_name | The name of the database to be created. |
| IF NOT EXISTS clause | Creates a database if the database name has not already been used. Otherwise throws an error. |
Example
CREATE DATABASE IF NOT EXISTS travel;
note
Names and unquoted identifiers are case-insensitive. Therefore, you must double-quote any of these fields for them to be case-sensitive.
