mysql> create table blabla (
-> bla int not null
-> );
Query OK, 0 rows affected (0.17 sec)
mysql> insert into blabla values (1);
Query OK, 1 row affected (0.12 sec)
mysql> update blabla set bla = null;
ERROR 1048 (23000): Column 'bla' cannot be null
A trukk:
mysql> SET sql_mode = 'TRADITIONAL';
Query OK, 0 rows affected (0.00 sec)