CREATE DATABASE
You are viewing an old version of this article. View
the current version here.
Syntax
CREATE [OR REPLACE] {DATABASE | SCHEMA} [IF NOT EXISTS] db_name [create_specification] ... create_specification: [DEFAULT] CHARACTER SET [=] charset_name | [DEFAULT] COLLATE [=] collation_name
Contents
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
. If the IF NOT EXISTS
clause is used, a warning will be returned if the database already exists, rather than an error.
OR REPLACE
MariaDB starting with 10.1.3
The OR REPLACE
clause was added in MariaDB 10.1.3
If the optional OR REPLACE
clause is used, it acts as a shortcut for:
DROP DATABASE IF EXISTS db_name; CREATE DATABASE db_name ...;
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.
Examples
CREATE DATABASE db1; Query OK, 1 row affected (0.18 sec) CREATE DATABASE db1; ERROR 1007 (HY000): Can't create database 'db1'; database exists CREATE OR REPLACE DATABASE db1; Query OK, 2 rows affected (0.00 sec) CREATE DATABASE IF NOT EXISTS db1; Query OK, 1 row affected, 1 warning (0.01 sec) SHOW WARNINGS; +-------+------+----------------------------------------------+ | Level | Code | Message | +-------+------+----------------------------------------------+ | Note | 1007 | Can't create database 'db1'; database exists | +-------+------+----------------------------------------------+
Setting the character sets and collation. See Setting Character Sets and Collations for more details.
CREATE DATABASE czech_slovak_names CHARACTER SET = 'keybcs2' COLLATE = 'keybcs2_bin';
See also
Comments
Comments loading...
Content reproduced on this site is the property of its respective owners,
and this content is not reviewed in advance by MariaDB. The views, information and opinions
expressed by this content do not necessarily represent those of MariaDB or any other party.