MySQL不支持布尔型,true和false在数据库中对应的是1和0
- mysql> create table stu18(
- -> flag boolean
- -> );
- Query OK, 0 rows affected (0.05 sec)
- mysql> desc stu18;
- +-------+------------+------+-----+---------+-------+
- | Field | Type | Null | Key | Default | Extra |
- +-------+------------+------+-----+---------+-------+
- | flag | tinyint(1) | YES | | NULL | |
- +-------+------------+------+-----+---------+-------+
- 1 row in set (0.00 sec)
- mysql> insert into stu18 values (true),(false);
- Query OK, 2 rows affected (0.00 sec)
- Records: 2 Duplicates: 0 Warnings: 0
- mysql> select * from stu18;
- +------+
- | flag |
- +------+
- | 1 |
- | 0 |
- +------+
- 2 rows in set (0.00 sec
复制代码小结: boolean型在MySQL中对应的是tinyint。 |