在MySQL中创建布尔列，将false设置为默认值? [英] Create boolean column in MySQL with false as default value?

问题描述

我想在MySQL中使用默认值为false的boolean列创建一个表.但是它接受NULL作为默认值...

I want to create a table in MySQL with a boolean column whose default value is false. But it's accepting NULL as default...

推荐答案

您必须指定0(表示false)或1(表示true)作为默认值.这是一个示例:

You have to specify 0 (meaning false) or 1 (meaning true) as the default. Here is an example:

create table mytable (
     mybool boolean not null default 0
);

仅供参考:boolean是tinyint(1)的别名.

以下是证明:

mysql> create table mytable (
    ->          mybool boolean not null default 0
    ->     );
Query OK, 0 rows affected (0.35 sec)

mysql> insert into mytable () values ();
Query OK, 1 row affected (0.00 sec)

mysql> select * from mytable;
+--------+
| mybool |
+--------+
|      0 |
+--------+
1 row in set (0.00 sec)

仅供参考:我的测试是在以下版本的MySQL上完成的:

FYI: My test was done on the following version of MySQL:

mysql> select version();
+----------------+
| version()      |
+----------------+
| 5.0.18-max-log |
+----------------+
1 row in set (0.00 sec)

这篇关于在MySQL中创建布尔列，将false设置为默认值?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！