1 2 3 4 5 6 7 8 9 |
create table t1 (a int, b int not null, c int null, d int not null, pk int primary key); show create table t1; insert into t1 values (0,0, 0, 0,0); --error ER_BAD_NULL_ERROR insert into t1 values (NULL, NULL, NULL, NULL, 1); insert into t1 values (NULL, 1, NULL, 1, 2); --error ER_BAD_NULL_ERROR insert into t1 values (1,2,3,NULL, 3); drop table t1; |