+-------------+--------------+------+-----+---------+-------+
| pid | varchar(15) | NO | PRI | NULL | |
| pname | varchar(30) | NO | | NULL | |
| pcomp | varchar(30) | NO | | NULL | |
| madew | varchar(20) | YES | | NULL | |
| madedate | date | YES | | NULL | |
| rprice | float | YES | | NULL | |
| cprice | float | YES | | NULL | |
| count | int(11) | YES | | NULL | |
| description | varchar(100) | YES | | NULL | |
+-------------+--------------+------+-----+---------+-------+
9 rows in set (0.02 sec)
mysql> insert into productlist values(11020356,icebox,Haier,Qingdao,2005-04-29,3
005.4,2999.9,100,Guochan);
ERROR 1054 (42S22): Unknown column 'icebox' in 'field list'
mysql> insert into productlist values(`11020356`,`电冰箱`,`Haier`,`青岛`,`2005-0
4-28`,3005.4,2999.9,100,`国产优质品牌`);
ERROR 1054 (42S22): Unknown column '11020356' in 'field list'
mysql> insert into productlist(pid,pname,pcomp,madew,madedate,rprice,cprice,coun
t,description) values(`11020356`,`电冰箱`,`Haier`,`青岛`,`2005-04-28`,3005.4,299
9.9,100,`国产优质品牌`);
ERROR 1054 (42S22): Unknown column '11020356' in 'field list'
mysql> insert into productlist values(11020356,icebox,Haier,Qingdao,2005-04-29,3
005.4,2999.9,100,Guochan);
ERROR 1054 (42S22): Unknown column 'icebox' in 'field list'
是因为你的第二个字段是varchar类型的,应该把icebox加上引号
第二个错误和第三个错误:
mysql> insert into productlist values(`11020356`,`电冰箱`,`Haier`,`青岛`,`2005-0
4-28`,3005.4,2999.9,100,`国产优质品牌`);
ERROR 1054 (42S22): Unknown column '11020356' in 'field list'
mysql> insert into productlist(pid,pname,pcomp,madew,madedate,rprice,cprice,coun
t,description) values(`11020356`,`电冰箱`,`Haier`,`青岛`,`2005-04-28`,3005.4,299
9.9,100,`国产优质品牌`);
ERROR 1054 (42S22): Unknown column '11020356' in 'field list'
是因为,你的pid是主键,唯一且非空,第一条数据已经把'11020356' 插入了,所以后面就不能插入了,因为重复了,也就是不唯一了。修改一下ID即可。
insert into productlist(pid,pname,pcomp,madew,madedate,rprice,cprice,coun
t,description) values('11020356','电冰箱','Haier','青岛','2005-04-28',3005.4,299
9.9,100,'国产优质品牌');