Syntax

CREATE DATABASE [ IF NOT EXISTS ] database_name;

Parameters

Parameter or clauseDescription
database_nameThe name of the database to be created.
IF NOT EXISTS clauseCreates 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. See also Identifiers.