CREATE DATABASE
Syntax
Description
CREATE DATABASE
creates a database with the given name. To use this statement, you need the CREATE privilege for the database. CREATE SCHEMA
is a synonym for CREATE DATABASE
.
For valid identifiers to use as database names, see Identifier Names.
OR REPLACE
If the optional OR REPLACE
clause is used, it acts as a shortcut for:
IF NOT EXISTS
When the IF NOT EXISTS
clause is used, MariaDB will return a warning instead of an error if the specified database already exists.
COMMENT
MariaDB starting with 10.5.0
From MariaDB 10.5.0, it is possible to add a comment of a maximum of 1024 bytes. If the comment length exceeds this length, a error/warning code 4144 is thrown. The database comment is also added to the db.opt file, as well as to the information_schema.schemata table.
Examples
Setting the character sets and collation. See Setting Character Sets and Collations for more details.
Comments, from MariaDB 10.5.0:
See Also
This page is licensed: GPLv2, originally from fill_help_tables.sql
Last updated
Was this helpful?