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 TINYINT CHECK(bool_val IN(0,1))
);
insert into bool_test(bool_val) values (0);
insert into bool_test(bool_val) values (1);
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 | 1 |
| 3 | null |