# **CREATE DATABASE**

## **Grammar Description**

The `CREATE DATABASE` statement is used to create a database.

## **Grammar Structure**

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

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

## **Example**

```sql
CREATE DATABASE IF NOT EXISTS test01;
```

**Expected results**

You can use [`SHOW DATABASES`](../Other/SHOW-Statements/show-databases.md) to check if the database has been created.

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

As you can see, in addition to the 6 system databases that already exist, the new database *test01* has been created.

## **limit**

- Currently only `UTF-8` character set is supported.
- `CHARACTER SET`, `COLLATE`, `ENCRYPTION` is currently available but cannot be effective.