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);
网友评论