• MySQL 建表语句 create table 中的列定义：

column_definition:

    data_type [NOT NULL | NULL] [DEFAULT default_value]

      [AUTO_INCREMENT] [UNIQUE [KEY]] [[PRIMARY] KEY]

      [COMMENT 'string']

      [COLUMN_FORMAT {FIXED|DYNAMIC|DEFAULT}]

      [reference_definition]

  | data_type [GENERATED ALWAYS] AS (expression)

      [VIRTUAL | STORED] [NOT NULL | NULL]

      [UNIQUE [KEY]] [[PRIMARY] KEY]

      [COMMENT 'string']

reference_definition:

    REFERENCES tbl_name (index_col_name,...)

      [MATCH FULL | MATCH PARTIAL | MATCH SIMPLE]

      [ON DELETE reference_option]

      [ON UPDATE reference_option]

reference_option:

    RESTRICT | CASCADE | SET NULL | NO ACTION | SET DEFAULT

• 可通过sql命令查看：help create table;