mysql> create table xx(id int not null); Query OK, 0 rows affected (0.01 sec) mysql> insert into xx values(); ERROR 1364 (HY000): Field 'id' doesn't have a default value mysql> insert into xx values(1);mysql> create table xx(id int not null); Query
mysql> create table xx(id int not null); Query OK, 0 rows affected (0.01 sec) mysql> insert into xx values(); ERROR 1364 (HY000): Field 'id' doesn't have a default value mysql> insert into xx values(1);mysql> create table xx(id int not null); Query