MySQL 8.0

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

CREATE TABLE bool_test(
  id INT AUTO_INCREMENT PRIMARY KEY,
  bool_val BOOL CHECK(bool_val IN(TRUE,FALSE))
);
insert into bool_test(bool_val) values (0);
insert into bool_test(bool_val) values (0x00);
insert into bool_test(bool_val) values (1);
insert into bool_test(bool_val) values ('1');
insert into bool_test(bool_val) values (true);
insert into bool_test(bool_val) values (null);
insert into bool_test(bool_val) values (2);

Check constraint 'bool_test_chk_1' is violated.


insert into bool_test(bool_val) values (-1);

Check constraint 'bool_test_chk_1' is violated.


select * from bool_test


id
bool_val


1
0

2
0

3
1

4
1

5
1

6
null


show create table bool_test


Table
Create Table


bool_test
CREATE TABLE `bool_test` (
  `id` int NOT NULL AUTO_INCREMENT,
  `bool_val` tinyint(1) DEFAULT NULL,
  PRIMARY KEY (`id`),
  CONSTRAINT `bool_test_chk_1` CHECK ((`bool_val` in (true,false)))
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci

id	bool_val
1	0
2	0
3	1
4	1
5	1
6	null