ERROR 1136 (21S01): Column count doesn't match value count at row 1

CREATE TABLE `goods_table` (
  `id` int(4) AUTO_INCREMENT NOT NULL ,
  `name` varchar(45) NOT NULL,
  `kind` varchar(20) NOT NULL,
  `price` int(11) NOT NULL,
  `discount` int(11) DEFAULT NULL,
  `store` int(11) NOT NULL,
  `detail` varchar(100) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

insert into goods_table values("XIAOMI3","F",1999,9,4000);

转载于:https://www.jianshu.com/p/c147533f1efd