1set sql_mode='strict_all_tables'; 2create table t1 (a int not null, b int); 3insert t1 (b) values (1); 4ERROR HY000: Field 'a' doesn't have a default value 5create trigger trgi before insert on t1 for each row 6case new.b 7when 10 then 8set new.a = new.b; 9when 30 then 10set new.a = new.a; 11else 12do 1; 13end case| 14insert t1 (b) values (10); 15insert t1 (b) values (20); 16ERROR HY000: Field 'a' doesn't have a default value 17insert t1 (b) values (30); 18select * from t1; 19a b 2010 10 210 30 22drop table t1; 23set sql_mode=default; 24set sql_mode=''; 25create table t1 ( 26id int(11) not null auto_increment primary key, 27data1 varchar(10) not null, 28data2 varchar(10) not null 29); 30insert into t1 (data2) values ('x'); 31Warnings: 32Warning 1364 Field 'data1' doesn't have a default value 33create trigger test_trigger before insert on t1 for each row begin end; 34insert into t1 (data2) values ('y'); 35Warnings: 36Warning 1364 Field 'data1' doesn't have a default value 37select * from t1; 38id data1 data2 391 x 402 y 41drop table t1; 42set sql_mode=default; 43