|
1878.5.4
by Brian Aker
Update documentation. |
1 |
CREATE SCHEMA
|
|
1994.4.123
by Marisa Plumb
doc fixes |
2 |
==============
|
3 |
||
4 |
CREATE SCHEMA enters a new schema into the current database. The schema name used must be distinct from the name of any existing schema. |
|
|
1887.3.1
by Brian Aker
Update to documentation for create table and create schema. |
5 |
|
|
2194.5.3
by Andrew Hutchings
Markup fixes |
6 |
.. code-block:: mysql |
7 |
||
8 |
CREATE SCHEMA [IF NOT EXISTS] schema_name |
|
9 |
[engine_options] ... |
|
10 |
||
11 |
engine_options
|
|
12 |
--------------
|
|
13 |
||
|
2363.1.2
by Brian Aker
Fix documentation for replication. |
14 |
You can specify the storage engine to use for creating the schema. Please note, there is currently only one engine. |
|
1994.4.123
by Marisa Plumb
doc fixes |
15 |
|
|
2194.5.3
by Andrew Hutchings
Markup fixes |
16 |
::
|
17 |
||
|
1887.3.1
by Brian Aker
Update to documentation for create table and create schema. |
18 |
engine_option [[,] engine_option] ...
|
19 |
||
|
2363.1.2
by Brian Aker
Fix documentation for replication. |
20 |
collate
|
21 |
-------
|
|
|
2194.5.3
by Andrew Hutchings
Markup fixes |
22 |
|
|
1994.4.123
by Marisa Plumb
doc fixes |
23 |
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. |
24 |
||
|
2194.5.3
by Andrew Hutchings
Markup fixes |
25 |
::
|
26 |
||
|
1887.3.1
by Brian Aker
Update to documentation for create table and create schema. |
27 |
[DEFAULT] COLLATE = collation_name
|
28 |
{ engine_specific }
|
|
|
2363.1.2
by Brian Aker
Fix documentation for replication. |
29 |
|
30 |
||
31 |
REPLICATE
|
|
32 |
---------
|
|
33 |
||
34 |
Specify whether or not a SCHEMA should be replicated. |
|
35 |
||
36 |
:: |
|
37 |
||
38 |
REPLICATE=[TRUE|FALSE] |