Mysql ERROR 1064 (42000)

时间:2023-03-09 16:43:47
Mysql ERROR 1064 (42000)

创建了一个表:

 +-------------+--------------+------+-----+---------+----------------+
| 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,问题解决。