mysql设置主键id后，报错Field 'id' doesn't have a default value,Time: 0.000000s

Question

mysql报错Field 'id' doesn't have a default value,Time: 0.000000s

CREATE TABLE t(
    id INT PRIMARY KEY NOT NULL AUTO_INCREMENT,
    name VARCHAR(20) NOT NULL,
    price FLOAT NOT NULL,
    desp VARCHAR(20) NOT NULL
) auto_increment=1;

INSERT INTO t(name, price, desp) VALUES
    ("p", 2.0, "bl"), ("rr", 500.0, "sis"), 
    ("wae", 3000.0, "add"), ("aer", 4.0, "ad");

Answer 1

没有报错，我这边测试正常，应该是你建表成功后，修改了表结构没有重新执行建表语句，删除表，重新建表再试试。