749      windows

CREATE DATABASE__數據定義語言_SQL語法參考_雲數據庫 OceanBase-阿裏雲

格式

CREATE DATABASE [IF NOT EXISTS] dbname 
     [create_specification_list];

create_specification_list: 
     create_specification [, create_specification…]

create_specification: 
     [DEFAULT] {CHARACTER SET | CHARSET} [=] charsetname 
     | [DEFAULT] COLLATE [=] collationname
     | REPLICA_NUM [=] num 
     | PRIMARY_ZONE [=] zone

CREATE DATABASE用於創建數據庫，並可以指定數據庫的默認屬性（如數據庫默認字符集,校驗規則等）。

• REPLICA_NUM指定副本數,副本數必須與zone的數量相等，默認情況下無需設置；
• PRIMARY_ZONE指定主zone的名稱。

舉例

Oceanbase>create database test1 default charset utf8mb4 collate utf8mb4_general_ci replica_num 3 primary_zone ET15SQA_1;
Query OK, 0 rows affected (0.04 sec)

Oceanbase>show create database test1;
+----------+--------------------------------------------------------------------------------------------------+
| Database | Create Database                                                                                  |
+----------+--------------------------------------------------------------------------------------------------+
| test1    | CREATE DATABASE `test1` DEFAULT CHARACTER SET = utf8mb4 REPLICA_NUM = 3 PRIMARY_ZONE = ET15SQA_1 |
+----------+--------------------------------------------------------------------------------------------------+
1 row in set (0.01 sec)

最後更新：2016-11-24 11:23:47

  上一篇： 數學函數__函數_SQL語法參考_雲數據庫 OceanBase-阿裏雲

  下一篇： ALTER_DATABASE__數據定義語言_SQL語法參考_雲數據庫 OceanBase-阿裏雲