BIT类型,用于存放位字段类型,BIT(M)可以存放多位二进制数,M的范围是1-64,默认是1,如:
mysql> create table test(id int primary key,col1 bit);
Query OK, 0 rows affected (0.03 sec)
mysql> desc test;
+-------+---------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+-------+---------+------+-----+---------+-------+
| id | int(11) | NO | PRI | NULL | |
| col1 | bit(1) | YES | | NULL | |
+-------+---------+------+-----+---------+-------+
2 rows in set (0.00 sec)
直接使用select是无法看到bit类型的内容的,
mysql> insert into test values (1,1);
Query OK, 1 row affected (0.00 sec)
mysql> select * from test;
+----+------+
| id | col1 |
+----+------+
| 1 | |
+----+------+
1 row in set (0.00 sec)
可以用bin()或hex()函数进行读取,