Product Solutions Support
Try MemSQL

CREATE DATABASE

Creates a database.

Syntax

CREATE DATABASE [IF NOT EXISTS] db_name [WITH {SYNC | ASYNC} REPLICATION] [PARTITIONS n]
    [create_specification] ...

create_specification:
    [DEFAULT] CHARACTER SET [=] charset_name


-- "schema" is an alias for "database"
CREATE SCHEMA [IF NOT EXISTS]...

Remarks

Example

memsql> CREATE DATABASE IF NOT EXISTS test;
Query OK, 1 row affected (0.18 sec)
Was this article useful?