Open nene opened 4 months ago
TEMPORARY
IF NOT EXISTS
NULL | NOT NULL
DEFAULT { literal | (expr) }
VISIBLE | INVISIBLE
AUTO_INCREMENT
UNIQUE [KEY]
[PRIMARY] KEY
COMMENT 'string'
COLLATE collation_name
COLUMN_FORMAT {FIXED | DYNAMIC | DEFAULT}
[SECONDARY_]ENGINE_ATTRIBUTE [=] 'string'
STORAGE {DISK | MEMORY}
references_def
CHECK (expr) [[NOT] ENFORCED]
[GENERATED ALWAYS] AS (expr)
GENERATED ALWAYS ... {VIRTUAL | STORED}
{INDEX | KEY} [index_name] [index_type] (key_part,...) [index_option]...
{FULLTEXT | SPATIAL} [INDEX | KEY] [index_name] (key_part,...) [index_option] ...
PRIMARY KEY [index_type] (key_part,...) [index_option]...
UNIQUE [INDEX | KEY] [index_name] [index_type] (key_part,...) [index_option]...
FOREIGN KEY [index_name] (col_name, ...) references_def
USING {BTREE | HASH}
KEY_BLOCK_SIZE [=] value
index_type
WITH PARSER parser_name
{col_name [(length)] | (expr)} [ASC | DESC]
REFERENCES tbl_name (key_part,...)
[MATCH FULL | MATCH PARTIAL | MATCH SIMPLE]
[ON DELETE reference_option]
[ON UPDATE reference_option]
RESTRICT | CASCADE | SET NULL | NO ACTION | SET DEFAULT
=
name [=] value
START TRANSACTION
TABLESPACE tablespace_name [STORAGE DISK]
[TABLESPACE tablespace_name] STORAGE MEMORY
UNION [=] (tbl_name[,tbl_name]...)
PARTITION BY [LINEAR] HASH(expr)
PARTITION BY [LINEAR] KEY [ALGORITHM={1 | 2}] (column_list)
PARTITION BY RANGE{(expr) | COLUMNS(column_list)}
PARTITION BY LIST{(expr) | COLUMNS(column_list)}
PARTITIONS num
SUBPARTITION BY [LINEAR] HASH(expr)
SUBPARTITION BY [LINEAR] KEY [ALGORITHM={1 | 2}] (column_list)
SUBPARTITION BY ... [SUBPARTITIONS num]
partition_name
VALUES LESS THAN {(expr | value_list) | MAXVALUE}
VALUES IN (value_list)
[STORAGE] ENGINE
COMMENT
DATA DIRECTORY
INDEX DIRECTORY
MAX_ROWS
MIN_ROWS
TABLESPACE
logical_name
IGNORE | REPLACE
AS query
[AS] query
LIKE old_table_name
( LIKE old_table_name )
TEMPORARYIF NOT EXISTSNULL | NOT NULLDEFAULT { literal | (expr) }VISIBLE | INVISIBLEAUTO_INCREMENTUNIQUE [KEY][PRIMARY] KEYCOMMENT 'string'COLLATE collation_nameCOLUMN_FORMAT {FIXED | DYNAMIC | DEFAULT}[SECONDARY_]ENGINE_ATTRIBUTE [=] 'string'STORAGE {DISK | MEMORY}references_defCHECK (expr) [[NOT] ENFORCED][GENERATED ALWAYS] AS (expr)GENERATED ALWAYS ... {VIRTUAL | STORED}{INDEX | KEY} [index_name] [index_type] (key_part,...) [index_option]...{FULLTEXT | SPATIAL} [INDEX | KEY] [index_name] (key_part,...) [index_option] ...PRIMARY KEY [index_type] (key_part,...) [index_option]...UNIQUE [INDEX | KEY] [index_name] [index_type] (key_part,...) [index_option]...FOREIGN KEY [index_name] (col_name, ...) references_defCHECK (expr) [[NOT] ENFORCED]USING {BTREE | HASH}KEY_BLOCK_SIZE [=] valueindex_typeWITH PARSER parser_nameCOMMENT 'string'VISIBLE | INVISIBLE[SECONDARY_]ENGINE_ATTRIBUTE [=] 'string'{col_name [(length)] | (expr)} [ASC | DESC]REFERENCES tbl_name (key_part,...)[MATCH FULL | MATCH PARTIAL | MATCH SIMPLE][ON DELETE reference_option][ON UPDATE reference_option]RESTRICT | CASCADE | SET NULL | NO ACTION | SET DEFAULT=signname [=] valueSTART TRANSACTIONTABLESPACE tablespace_name [STORAGE DISK][TABLESPACE tablespace_name] STORAGE MEMORYUNION [=] (tbl_name[,tbl_name]...)PARTITION BY [LINEAR] HASH(expr)PARTITION BY [LINEAR] KEY [ALGORITHM={1 | 2}] (column_list)PARTITION BY RANGE{(expr) | COLUMNS(column_list)}PARTITION BY LIST{(expr) | COLUMNS(column_list)}PARTITIONS numSUBPARTITION BY [LINEAR] HASH(expr)SUBPARTITION BY [LINEAR] KEY [ALGORITHM={1 | 2}] (column_list)SUBPARTITION BY ... [SUBPARTITIONS num]partition_nameVALUES LESS THAN {(expr | value_list) | MAXVALUE}VALUES IN (value_list)[STORAGE] ENGINE,COMMENT,DATA DIRECTORY,INDEX DIRECTORY,MAX_ROWS,MIN_ROWS,TABLESPACE.logical_nameIGNORE | REPLACEAS query[AS] query(no AS keyword necessary!)LIKE old_table_name( LIKE old_table_name )