D75AsrvU

1интаксис оператора CREATE TABLE
2
3CREATE [TEMPORARY] TABLE [IF NOT EXISTS] tbl_name [(create_definition,...)]
4[table_options] [select_statement]
5
6create_definition:
7  col_name type [NOT NULL | NULL] [DEFAULT default_value] [AUTO_INCREMENT]
8            [PRIMARY KEY] [reference_definition]
9  или   PRIMARY KEY (index_col_name,...)
10  или   KEY [index_name] (index_col_name,...)
11  или   INDEX [index_name] (index_col_name,...)
12  или   UNIQUE [INDEX] [index_name] (index_col_name,...)
13  или   FULLTEXT [INDEX] [index_name] (index_col_name,...)
14  или   [CONSTRAINT symbol] FOREIGN KEY [index_name] (index_col_name,...)
15            [reference_definition]
16  или   CHECK (expr)
17
18type:
19        TINYINT[(length)] [UNSIGNED] [ZEROFILL]
20  или   SMALLINT[(length)] [UNSIGNED] [ZEROFILL]
21  или   MEDIUMINT[(length)] [UNSIGNED] [ZEROFILL]
22  или   INT[(length)] [UNSIGNED] [ZEROFILL]
23  или   INTEGER[(length)] [UNSIGNED] [ZEROFILL]
24  или   BIGINT[(length)] [UNSIGNED] [ZEROFILL]
25  или   REAL[(length,decimals)] [UNSIGNED] [ZEROFILL]
26  или   DOUBLE[(length,decimals)] [UNSIGNED] [ZEROFILL]
27  или   FLOAT[(length,decimals)] [UNSIGNED] [ZEROFILL]
28  или   DECIMAL(length,decimals) [UNSIGNED] [ZEROFILL]
29  или   NUMERIC(length,decimals) [UNSIGNED] [ZEROFILL]
30  или   CHAR(length) [BINARY]
31  или   VARCHAR(length) [BINARY]
32  или   DATE
33  или   TIME
34  или   TIMESTAMP
35  или   DATETIME
36  или   TINYBLOB
37  или   BLOB
38  или   MEDIUMBLOB
39  или   LONGBLOB
40  или   TINYTEXT
41  или   TEXT
42  или   MEDIUMTEXT
43  или   LONGTEXT
44  или   ENUM(value1,value2,value3,...)
45  или   SET(value1,value2,value3,...)
46
47index_col_name:
48        col_name [(length)]
49
50reference_definition:
51        REFERENCES tbl_name [(index_col_name,...)]
52                   [MATCH FULL | MATCH PARTIAL]
53                   [ON DELETE reference_option]
54                   [ON UPDATE reference_option]
55
56reference_option:
57        RESTRICT | CASCADE | SET NULL | NO ACTION | SET DEFAULT
58
59table_options:
60        TYPE = {BDB | HEAP | ISAM | InnoDB | MERGE | MRG_MYISAM | MYISAM }
61или     AUTO_INCREMENT = #
62или     AVG_ROW_LENGTH = #
63или     CHECKSUM = {0 | 1}
64или     COMMENT = "string"
65или     MAX_ROWS = #
66или     MIN_ROWS = #
67или     PACK_KEYS = {0 | 1 | DEFAULT}
68или     PASSWORD = "string"
69или     DELAY_KEY_WRITE = {0 | 1}
70или     ROW_FORMAT= { default | dynamic | fixed | compressed }
71или     RAID_TYPE= {1 | STRIPED | RAID0 } RAID_CHUNKS=#  RAID_CHUNKSIZE=#
72или     UNION = (table_name,[table_name...])
73или     INSERT_METHOD= {NO | FIRST | LAST }
74или     DATA DIRECTORY="абсолютный путь к каталогу"
75или     INDEX DIRECTORY="абсолютный путь к каталогу"
76
77select_statement:
78        [IGNORE | REPLACE] SELECT ...  (любое корректное выражение SELECT)