mysql>进不去_mysql插入不了啊，求解释啊

+-------------+--------------+------+-----+---------+-------+|pid|varchar(15)|NO|PRI|NULL|||pname|varchar(30)|NO||NULL|||pcomp|varchar(30)|NO||NULL|||madew|varchar(20)|YE...

+-------------+--------------+------+-----+---------+-------+

| 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'

展开