- 论坛徽章:
- 0
|
mysql> create table test(id bit(;
Query OK, 0 rows affected (0.00 sec)
mysql> insert into test values(23);
Query OK, 1 row affected (0.00 sec)
mysql> select bin(id),hex(id) from test;
+---------+---------+
| bin(id) | hex(id) |
+---------+---------+
| 0 | 17 |
+---------+---------+
1 row in set (0.00 sec)
mysql> select bin(23);
+---------+
| bin(23) |
+---------+
| 10111 |
+---------+
1 row in set (0.00 sec)
为什么从表中查询结果是0呢?
是create table test(id bit(;但论坛显示是个头像
[ 本帖最后由 kfddc 于 2008-7-7 09:20 编辑 ] |
|