CREATE DATABASE語句解釋

本文為mariadb官方手冊:create database的譯文。

語法

CREATE?[OR?REPLACE]?{DATABASE?|?SCHEMA}?[IF?NOT?EXISTS]?db_name  ????[create_specification]?...    create_specification:  ????[DEFAULT]?CHARACTER?SET?[=]?charset_name  ??|?[DEFAULT]?COLLATE?[=]?collation_name

描述

CREATE DATABASE創(chuàng)建一個給定名稱的數(shù)據(jù)庫。該語句要求對database具有CREATE權(quán)限。CREATE SCHEMA是CREATE DATABASE的同義詞。如果使用了IF NOT EXISTS子句,當數(shù)據(jù)庫已存在時將返回一條warning信息而不是返回錯誤。

OR REPLACE

MariaDB starting with 10.1.3 在MariaDB 10.1.3中引入了OR REPLACE子句。 如果使用了可選的OR REPLACE子句,它是下面語句的簡寫形式:

DROP?DATABASE?IF?EXISTS?db_name;CREATE?DATABASE?db_name?...;

IF NOT EXISTS

當使用了IF NOT EXISTS子句,當指定的數(shù)據(jù)庫已存在時,MariaDB將返回一個warning而不是錯誤信息。

示例

CREATE?DATABASE?db1;Query?OK,?1?row?affected?(0.18?sec)CREATE?DATABASE?db1;ERROR?1007?(HY000):?Can't?create?database?'db1';?database?existsCREATE?OR?REPLACE?DATABASE?db1;Query?OK,?2?rows?affected?(0.00?sec)CREATE?DATABASE?IF?NOT?EXISTS?db1;Query?OK,?1?row?affected,?1?warning?(0.01?sec)SHOW?WARNINGS;+-------+------+----------------------------------------------+|?Level?|?Code?|?Message??????????????????????????????????????|  +-------+------+----------------------------------------------+|?Note??|?1007?|?Can't?create?database?'db1';?database?exists?|  +-------+------+----------------------------------------------+

設(shè)置字符集和排序規(guī)則。詳細信息見設(shè)置字符集和排序規(guī)則

CREATE?DATABASE?czech_slovak_names?  ??CHARACTER?SET?=?'keybcs2'  ??COLLATE?=?'keybcs2_bin';

? 版權(quán)聲明
THE END
喜歡就支持一下吧
點贊7 分享