Mysql ERROR 1064 （42000）

標籤：

建立了一個表：

 1 +-------------+--------------+------+-----+---------+----------------+ 2 | Field       | Type         | Null | Key | Default | Extra          | 3 +-------------+--------------+------+-----+---------+----------------+ 4 | id          | int(11)      | NO   | PRI | NULL    | auto_increment | 5 | model       | varchar(80)  | NO   |     | NULL    |                | 6 | type        | varchar(32)  | NO   |     | NULL    |                | 7 | name        | varchar(48)  | NO   |     | NULL    |                | 8 | price       | varchar(32)  | NO   |     | NULL    |                | 9 | salePrice   | varchar(32)  | NO   |     | NULL    |                |10 | traderPrice | varchar(32)  | NO   |     | NULL    |                |11 | picture     | varchar(128) | NO   |     | NULL    |                |12 | desc        | varchar(128) | NO   |     | NULL    |                |13 +-------------+--------------+------+-----+---------+----------------+

執行以下語句：

mysql> insert into product (model,type,name,price,salePrice,traderPrice,picture,desc) values("WZC504-TZ","開關","雙速","60","51","41","eb3.jpg","");

得到錯誤資訊：

1 ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that2 corresponds to your MySQL server version for the right syntax to use near ‘desc3 ) values("WZC504-TZ","開關","雙速","60","51","41","eb3.jpg","")‘ at line 1

原因：列名跟Mysql的關鍵字重疊。

那就應該是desc的起名問題了，修改為describe，依然報錯。這兩個都是Mysql的關鍵字！

改成description，問題解決。

 

Mysql ERROR 1064 （42000）