错误代码: 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
下图为:表test
若我要将describe字段修改为 我,sql语句为
UPDATE test SET describe='我' WHERE id='1'
则会报错,原因是describe字段与sql关键字冲突 ,sql语句改为如下(用将字段括起来,
为Tab键上面那个键)
UPDATE test SET `describe`='我' WHERE id='1'
修改成功,如下