14.8.2 Specifying the Row Format for a Table 指定表的Row Format

14.8.2 Specifying the Row Format for a Table  指定表的Row Format


你指定row format 对于一个表使用CREATE TABLE and ALTER TABLE statements 来指定行格式，比如:

CREATE TABLE t1 (f1 int unsigned) ROW_FORMAT=DYNAMIC ENGINE=INNODB;

InnoDB ROW_FORMAT 选项包括COMPACT, REDUNDANT, DYNAMIC, and COMPRESSED. 


对于InnoDB 表,行是存储在COMPACT 格式(ROW_FORMAT=COMPACT) 默认的,