php - SQL 更新查询错误不知道出了什么问题

Question

SQL查询:

UPDATE a2418693_GCM.driver SET lat = 78.54555,
LONG = 78.45544252 WHERE username =  'rakesh'

MySQL 消息:文档

#1064 - 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 'long=78.45544252 WHERE username='rakesh'' at line 2

这里有什么问题？

我正在使用以下查询..

update a2418693_GCM.driver 
SET lat=78.54555,long=78.45544252 WHERE username='rakesh'

Answer 1

它给您一个语法错误，因为您使用了保留的 MySQL 关键字“long”。要解决此问题，您需要重命名您的列或使用反引号以“MySQL”方式将其转义

UPDATE `a2418693_GCM`.`driver` SET 
`lat` ='78.54555',
`long` ='78.45544252' 
WHERE `username` ='rakesh'