~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to docs/create_schema.rst

  • Committer: Marisa Plumb
  • Date: 2011-03-30 03:12:02 UTC
  • mto: This revision was merged to the branch mainline in revision 2283.
  • Revision ID: marisa.plumb@gmail.com-20110330031202-z1q0xlnzdrqobvjv
doc fixes

Show diffs side-by-side

added added

removed removed

Lines of Context:
1
1
CREATE SCHEMA
2
 
=============
 
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.
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.
 
24
 
19
25
::
20
26
 
21
27
  [DEFAULT] COLLATE = collation_name