How to create boolean column in MySQL with false as default value?

To create a column with ‘false’ as the default value, we can use the concept of “default” at the time of creation of the table.

Note − 0 represents false and 1 represents true.

Creating a table using “default” false.

mysql> create table TrueFalseTable
   -> (
   -> Adult boolean default false
   -> );
Query OK, 0 rows affected (0.65 sec)

Inserting records with no value, since we have set “default” above.

mysql> insert into TrueFalseTable values();
Query OK, 1 row affected (0.16 sec)

To display records.

mysql> select *from TrueFalseTable;

The following output shows that the default is set to Boolean false i.e. 0

+-------+
| Adult |
+-------+
|     0 |
+-------+
1 row in set (0.00 sec)

Ankith Reddy

Updated on: 30-Jul-2019

5K+ Views

Get certified by completing the course

Get Started