COLUMN_FORMAT 的值:FIXED、DYNAMIC、DEFAULT 的区别(待补充)

  • 参考===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']

posted on 2019-01-22 20:47  cag2050  阅读(369)  评论(0编辑  收藏  举报

导航