mysql default true_mysql boolean类型default 0/1 not true,false | 学步园

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

);

FYI: boolean is an alias for 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)

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中设置字段类型为boolean。mysql会自动变成tinyint(1)。明白了为什么default value 为0/1。