ERROR 1364 (HY000): Field 'id' doesn't have a default value

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);

原文地址:https://www.cnblogs.com/hzcya1995/p/13349780.html