my_table
包含enabled
字段,其定义为:enabled BIT NOT NULL DEFAULT 0
.
此表有多行enabled = b'0'
,多行enabled = b'1'
.
然而,这两方面:
SELECT * from my_table WHERE enabled = b'0';
这是:
SELECT * from my_table WHERE enabled = b'1';
在enabled
栏中显示空白:
+----+---------+
| id | enabled |
+----+---------+
| 1 | |
| 2 | |
+----+---------+
为什么?我怎样才能看到enabled
字段的值?
$ mysql --version
mysql Ver 14.14 Distrib 5.1.63, for debian-linux-gnu (x86_64) using readline 6.1