Skip to content

CREATE DATABASE

Description

Create a database.

Syntax

> CREATE DATABASE [IF NOT EXISTS] <database_name> [create_option] ...

> create_option: [DEFAULT] {
    CHARACTER SET [=] charset_name
  | COLLATE [=] collation_name
  | ENCRYPTION [=] {'Y' | 'N'}
}

Examples

CREATE DATABASE IF NOT EXISTS test01;

Expected Result

You can use SHOW DATABASES to check if the databases have been created.

mysql> show databases;
+--------------------+
| Database           |
+--------------------+
| mo_task            |
| information_schema |
| mysql              |
| system_metrics     |
| system             |
| test01             |
| mo_catalog         |
+--------------------+
10 rows in set (0.01 sec)

You can see that the new database test01 has been created in addition to the six system databases.

Constraints

  • Only UTF-8 CHARACTER SET is supported for now.
  • CHARACTER SET, COLLATE, ENCRYPTION can be used but don't work.