Mp8TZ1Gp

1CREATE [TEMPORARY] TABLE [IF NOT EXISTS] tbl_name
2    (create_definition,...)
3    [table_options]
4    [partition_options]
5
6-- irrelevant stuff omitted
7
8column_definition:
9    data_type [NOT NULL | NULL] [DEFAULT default_value]
10      [AUTO_INCREMENT] [UNIQUE [KEY]] [[PRIMARY] KEY]
11      [COMMENT 'string']
12      [COLUMN_FORMAT {FIXED|DYNAMIC|DEFAULT}]
13      [STORAGE {DISK|MEMORY|DEFAULT}]
14      [reference_definition]
15
16-- irrelevant stuff omitted
17
18table_option:
19    AUTO_INCREMENT [=] value
20  | AVG_ROW_LENGTH [=] value
21
22-- many stuff omitted