语句如下：

    1. create_table_stmt:
    2.       CREATE TABLE [IF NOT EXISTS] table_name
    3.       (table_definition_list) [table_option_list] [partition_option];
    4.     | CREATE TABLE [IF NOT EXISTS] table_name
    5.       LIKE table_name;
    7. alter_table_stmt:
    8.       ALTER TABLE table_name
    9.       alter_table_action_list;
    10.     | RENAME TABLE rename_table_action_list;
    12. drop_table_stmt:
    13.     DROP TABLE [IF EXISTS] table_name_list;
    15. truncate_table_stmt:
    16.     TRUNCATE [TABLE] table_name;
    18. table_definition_list:
    19.     table_definition [, table_definition ...]
    21. table_definition:
    22.       column_definition
    23.     | [CONSTRAINT [constraint_name]] PRIMARY KEY index_desc
    24.     | [CONSTRAINT [constraint_name]] UNIQUE {INDEX | KEY} [index_name] index_desc
    25.     | {INDEX | KEY} [index_name] index_desc
    26.     | FULLTEXT [INDEX | KEY] [index_name] fulltext_index_desc
    28. column_definition_list:
    29.     column_definition [, column_definition ...]
    31. column_definition:
    32.     column_name data_type
    33.     [DEFAULT const_value] [AUTO_INCREMENT]
    34.     [NULL | NOT NULL] [[PRIMARY] KEY] [UNIQUE [KEY]] comment
    36. index_desc:
    37.    (column_desc_list) [index_type] [index_option_list]
    39. fulltext_index_desc:
    40.    (column_desc_list) CTXCAT(column_desc_list) [index_option_list]
    42. column_desc_list:
    43.     column_desc [, column_desc ...]
    45. column_desc:
    46.      column_name [(length)] [ASC | DESC]
    48. index_type:
    49.     USING BTREE
    51. index_option_list:
    52.     index_option [ index_option ...]
    54. index_option:
    55.       [GLOBAL | LOCAL]
    56.     | block_size
    57.     | compression
    58.     | STORING(column_name_list)
    59.     | comment
    61. table_option_list:
    62.     table_option [ table_option ...]
    64. table_option:
    65.       default_charset
    66.     | default_collate
    67.     | primary_zone
    68.     | replica_num
    69.     | table_tablegroup
    70.     | block_size
    71.     | compression
    72.     | AUTO_INCREMENT [=] INT_VALUE
    73.     | comment
    75. partition_option:
    76.       PARTITION BY HASH(expression)
    77.       [subpartition_option] PARTITIONS partition_count
    78.     | PARTITION BY KEY([column_name_list])
    79.       [subpartition_option] PARTITIONS partition_count
    80.     | PARTITION BY RANGE {(expression) | COLUMNS (column_name_list)}
    81.       [subpartition_option] (range_partition_list)
    83. subpartition_option:
    84.       SUBPARTITION BY HASH(expression)
    85.       SUBPARTITIONS subpartition_count
    86.     | SUBPARTITION BY KEY(column_name_list)
    87.       SUBPARTITIONS subpartition_count
    88.     | SUBPARTITION BY RANGE {(expression) | COLUMNS (column_name_list)}
    89.       (range_subpartition_list)
    91. range_partition_list:
    92.     range_partition [, range_partition ...]
    94. range_partition:
    95.     PARTITION partition_name
    96.     VALUES LESS THAN {(expression_list) | MAXVALUE}
    98. range_subpartition_list:
    99.     range_subpartition [, range_subpartition ...]
    101. range_subpartition:
    102.     SUBPARTITION subpartition_name
    103.     VALUES LESS THAN {(expression_list) | MAXVALUE}
    105. expression_list:
    106.     expression [, expression ...]
    108. alter_table_action_list:
    109.     alter_table_action [, alter_table_action ...]
    111. alter_table_action:
    112.       ADD [COLUMN] {column_definition | (column_definition_list)}
    113.     | CHANGE [COLUMN] column_name column_definition
    114.     | MODIFY [COLUMN] column_definition
    115.     | ALTER [COLUMN] column_name {SET DEFAULT const_value | DROP DEFAULT}
    116.     | DROP [COLUMN] column_name
    117.     | ADD [CONSTRAINT [constraint_name]] UNIQUE {INDEX | KEY} [index_name] index_desc
    118.     | ADD {INDEX | KEY} [index_name] index_desc
    119.     | ADD FULLTEXT [INDEX | KEY] [index_name] fulltext_index_desc
    120.     | ALTER INDEX index_name [VISIBLE | INVISIBLE]
    121.     | DROP {INDEX | KEY} index_name
    122.     | ADD PARTITION (range_partition_list)
    123.     | DROP PARTITION (partition_name_list)
    124.     | [SET] table_option_list
    125.     | RENAME [TO] table_name
    126.     | DROP TABLEGROUP
    128. rename_table_action_list:
    129.     rename_table_action [, rename_table_action ...]
    131. rename_table_action:
    132.     table_name TO table_name
    134. table_name_list:
    135.     table_name [, table_name ...]
    137. column_name_list:
    138.     column_name [, column_name ...]
    140. partition_name_list:
    141.     partition_name [, partition_name ...]
    143. partition_count | subpartition_count:
    144.     INT_VALUE