本文為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)聲明
文章版權(quán)歸作者所有,未經(jīng)允許請勿轉(zhuǎn)載。
THE END