66.笔记 MySQL学习——MySQL的BIT数据类型

66.笔记 MySQL学习——MySQL的BIT数据类型

创建一个表如下：

create table t (b bit(3));

执行插入，查询：

MariaDB [mytest]> insert into t(b) values(0),(b'11'),(b'101'),(b'111');

Query OK, 4 rows affected (0.06 sec)

Records: 4 Duplicates: 0  Warnings: 0

 

MariaDB [mytest]> select b+0,cast(b as unsigned)from t;

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

| b+0 | cast(b as unsigned) |

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

|   0 |                   0 |

|   3 |                   3 |

|   5 |                   5 |

|   7 |                   7 |

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

4 rows in set (0.03 sec)