← Back to branch summary

~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to docs/create_table.rst

  • Committer: Mark Atwood
  • Date: 2012-01-03 02:42:00 UTC
  • mfrom: (2482.1.2 drizzle-build)
  • Revision ID: me@mark.atwood.name-20120103024200-2kjnoze027o3dnwy
merge lp:~brianaker/drizzle/icc-warnings

Show diffs side-by-side

added added

removed removed

Lines of Context:
docs/create_table.rst
 
1
CREATE TABLE
 
2
============
 
3
 
 
4
A CREATE statement in SQL creates an object inside of Drizzle. One of
 
5
the most common CREATE commands is the CREATE TABLE command.
 
6
 
 
7
.. code-block:: mysql
 
8
 
 
9
    CREATE [TEMPORARY] TABLE [IF NOT EXISTS] table_name
 
10
      (create_definition, ...)
 
11
      [engine_options]
 
12
      REPLICATE=[TRUE|FALSE] 
 
13
 
 
14
or:
 
15
 
 
16
.. code-block:: mysql
 
17
 
 
18
    CREATE [TEMPORARY] TABLE [IF NOT EXISTS] table_name
 
19
      [(create_definition, ...)]
 
20
      [engine_options]
 
21
      select_statement
 
22
      REPLICATE=[TRUE|FALSE] 
 
23
 
 
24
or:
 
25
 
 
26
.. code-block:: mysql
 
27
 
 
28
    CREATE [TEMPORARY] TABLE [IF NOT EXISTS] table_name
 
29
      LIKE different_table_name
 
30
      [engine_options]
 
31
      REPLICATE=[TRUE|FALSE] 
 
32
 
 
33
create_definition
 
34
-----------------
 
35
 
 
36
::
 
37
 
 
38
    column_name column_definition
 
39
    [CONSTRAINT [symbol] ] PRIMARY KEY [index_type]
 
40
    (index_column_name, ...)
 
41
    INDEX [index_name] (index_column_name, ...)
 
42
    (index_column_name, ...)
 
43
    [CONSTRAINT [symbol] ] UNIQUE [INDEX]
 
44
    (index_column_name, ...)
 
45
    [CONSTRAINT [symbol] ] FOREIGN KEY [index_name] (index_column_name, ...)
 
46
    reference_definition
 
47
    CHECK (expr)
 
48
 
 
49
column_definition
 
50
-----------------
 
51
 
 
52
::
 
53
 
 
54
        data_type [NOT NULL | NULL] [DEFAULT default_value]
 
55
    [AUTO_INCREMENT] [UNIQUE [KEY] | [PRIMARY] KEY]
 
56
    [COMMENT 'string']
 
57
    [reference_definition]
 
58
 
 
59
data_type
 
60
---------
 
61
 
 
62
        * INTEGER
 
63
        * BIGINT
 
64
        * DOUBLE[(length, decimals)]
 
65
        * DECIMAL[(length[,decimals])]
 
66
        * DATE
 
67
        * TIMESTAMP
 
68
        * DATETIME
 
69
        * VARCHAR(length) [COLLATE collation_name]
 
70
        * VARBINARY(length)
 
71
        * BLOB
 
72
        * TEXT [BINARY] [COLLATE collation_name]
 
73
        * ENUM(value1, value2, value3, ...) [COLLATE collation_name]
 
74
 
 
75
reference_option
 
76
----------------
 
77
 
 
78
  RESTRICT | CASCADE | SET NULL | NO ACTION
 
79
 
 
80
engine_options
 
81
---------------
 
82
 
 
83
    engine_option [[,] engine_option] ...
 
84
 
 
85
engine_option
 
86
-------------
 
87
 
 
88
  ENGINE = engine_name
 
89
  { engine_specific }
 
90
 
 
91
REPLICATE
 
92
---------
 
93
 
 
94
Specify whether or not a TABLE should be replicated.
 
95
 
 
96
  REPLICATE=[TRUE|FALSE]