CREATE SCHEMA enters a new schema into the current database. The schema name used must be distinct from the name of any existing schema.
3
5
4
6
.. code-block:: mysql
5
7
9
11
engine_options
10
12
--------------
11
13
14
You can specify the storage engine to use for creating the schema.
15
12
16
::
13
17
14
18
engine_option [[,] engine_option] ...
16
20
engine_option
17
21
-------------
18
22
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.