1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
|
CREATE SCHEMA
==============
CREATE SCHEMA enters a new schema into the current database. The schema name used must be distinct from the name of any existing schema.
.. code-block:: mysql
CREATE SCHEMA [IF NOT EXISTS] schema_name
[engine_options] ...
engine_options
--------------
You can specify the storage engine to use for creating the schema. Please note, there is currently only one engine.
::
engine_option [[,] engine_option] ...
collate
-------
There are default settings for character sets and collations at four levels: server, database, table, and column. The COLLATE clause specifies the default database collation.
::
[DEFAULT] COLLATE = collation_name
{ engine_specific }
REPLICATE
---------
Specify whether or not a SCHEMA should be replicated.
::
REPLICATE=[TRUE|FALSE]
|