在MySQL 中,可以使用 CREATE DATABASE 语句创建数据库,语法格式如下: CREATE {DATABASE | SCHEMA} [IF NOT EXISTS] DB_NAME [CREATE_SPECIFICATION [, CREATE_SPECIFICATION] ...] CREATE_SPECIFICATION: [DEFAULT] CHARACTER SET CHARSET_NAME | [DEFAULT] COLLATE COLLATION_NAME 创建数据库 #mysql>为提示符 ...
CREATE DATABASE与CREATE SCHEMA是等价的。 权限要求 执行CREATE DATABASE语句创建用户需要当前用户拥有全局的CREATE权限。有关 OceanBase 数据库权限的详细介绍,请参见MySQL 模式下的权限分类。 语法 CREATE{DATABASE|SCHEMA}[IFNOTEXISTS]database_name[database_option...]database_option:[DEFAULT]{CHARACTERSET|CHARS...
mysql> CREATE DATABASE db_test5 CHARACTER SET ‘utf8’; #输入数据库创建语句,只设定字符集。Query OK, 1 row affected, 1 warning (0.02 sec)mysql> CREATE DATABASE db_test6 COLLATE ‘utf8_unicode_520_ci’; #输入数据库创建语句,只设定排序规则。Query OK, 1 row affected, 1 warning (0.10 se...
Note: A database which has just been created is not current database. The user must have to instruct to make it the current database. A database needs to be created only once but a user must have to select it each time he intends to work with that database. MySQL: Setting the Defa...
CREATE{DATABASE|SCHEMA}[IFNOTEXISTS]db_name[create_option]...create_option:[DEFAULT]{CHARACTERSET[=]charset_name|COLLATE[=]collation_name|ENCRYPTION[=]{'Y'|'N'} } CREATE DATABASEcreates a database with the given name. To use this statement, you need theCREATEprivilege for the database.CR...
CREATE{DATABASE|SCHEMA}[IFNOTEXISTS]db_name[create_option]...create_option:[DEFAULT]{CHARACTERSET[=]charset_name|COLLATE[=]collation_name} CREATE DATABASEcreates a database with the given name. To use this statement, you need theCREATEprivilege for the database.CREATE SCHEMAis a synonym forCR...
一、mysql 中创建数据库的语法如下: 1、创建数据库的语法: create{database|schema}[if not exists]db_name[create_specification]--mysql在以在创建库的时候指定库的默认字符集,create_specification:[defualt]characterset[=]charset_name[default]collate[=]collation_name ...
rds:CreateDatabase create *DBInstance acs:rds:{#regionId}:{#accountId}:dbinstance/{#dbinstanceId} rds:ResourceTag 无 请求参数 名称类型必填描述示例值 DBInstanceId string 是 实例ID。可调用 DescribeDBInstances 获取。 rm-uf6wjk5*** DBName string 是 数据库名称。 说明 长度为 2~64 个字符。...
mysql>?CREATEDATABASEName:'CREATE DATABASE'Description: Syntax:CREATE{DATABASE|SCHEMA}[IF NOT EXISTS]db_name[create_specification]... create_specification:[DEFAULT]CHARACTERSET[=]charset_name|[DEFAULT]COLLATE[=]collation_nameCREATEDATABASEcreates adatabasewiththe given name.Tousethis ...
Valid values for the Ctype field: You can execute the SELECT DISTINCT collctype FROM pg_collation; statement to obtain the field value. The default value is en_US.utf8. gbk DBDescription string No The description of the database. The description must be 2 to 256 characters in length and ...