
创建了一个表:
+-------------+--------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+-------------+--------------+------+-----+---------+----------------+
| id | int() | NO | PRI | NULL | auto_increment |
| model | varchar() | NO | | NULL | |
| type | varchar() | NO | | NULL | |
| name | varchar() | NO | | NULL | |
| price | varchar() | NO | | NULL | |
| salePrice | varchar() | NO | | NULL | |
| traderPrice | varchar() | NO | | NULL | |
| picture | varchar() | NO | | NULL | |
| desc | varchar() | NO | | NULL | |
+-------------+--------------+------+-----+---------+----------------+
执行以下语句:
mysql> insert into product (model,type,name,price,salePrice,traderPrice,picture,
desc) values("WZC504-TZ","开关","双速","","","","eb3.jpg","");
得到错误信息:
ERROR (): You have an error in your SQL syntax; check the manual that
corresponds to your MySQL server version for the right syntax to use near 'desc
) values("WZC504-TZ","开关","双速","","","","eb3.jpg","")' at line 1
原因:列名跟Mysql的关键字重叠。
那就应该是desc的起名问题了,修改为describe,依然报错。这两个都是Mysql的关键字!
改成description,问题解决。