redundant 行记录格式

redundant 行记录格式

CREATE TABLE `mytest2` (

  `t1` varchar() DEFAULT NULL,

  `t2` varchar() DEFAULT NULL,

  `t3` char() DEFAULT NULL,

  `t4` varchar() DEFAULT NULL

) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=REDUNDANT

mysql> select * from mytest2;

+------+------+------+------+

| t1   | t2   | t3   | t4   |

+------+------+------+------+

| a    | bb   | bb   | ccc  |

| d    | ee   | ee   | fff  |

| d    | NULL | NULL | fff  |

+------+------+------+------+

mysql> select hex(t1),hex(t2),hex(t3),hex(t4) from mytest2;

+---------+---------+---------+---------+

| hex(t1) | hex(t2) | hex(t3) | hex(t4) |

+---------+---------+---------+---------+

|       |     |     |   |

|       |     |     |   |

|       | NULL    | NULL    |   |

+---------+---------+---------+---------+

 rows in set (0.00 sec)