redundant 行记录格式

最新推荐文章于 2024-03-06 22:54:51 发布

weixin_30488313

最新推荐文章于 2024-03-06 22:54:51 发布

阅读量118

点赞数

原文链接：http://www.cnblogs.com/zengkefu/p/5599452.html

版权

CREATE TABLE `mytest2` (
  `t1` varchar(10) DEFAULT NULL,
  `t2` varchar(10) DEFAULT NULL,
  `t3` char(10) DEFAULT NULL,
  `t4` varchar(10) 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) |
+---------+---------+---------+---------+
| 61      | 6262    | 6262    | 636363  |
| 64      | 6565    | 6565    | 666666  |
| 64      | NULL    | NULL    | 666666  |
+---------+---------+---------+---------+
3 rows in set (0.00 sec)