Syntax
------ 
CREATE [OR REPLACE] {DATABASE | SCHEMA} [IF NOT EXISTS]
db_name
 [create_specification] ...
 
create_specification:
 [DEFAULT] CHARACTER SET [=] charset_name
 | [DEFAULT] COLLATE [=] collation_name
 
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
 
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';
 


URL: https://mariadb.com/kb/en/create-database/