各位大神看一看吧，这个错误我调一天了。。。SQL的修改语句
小弟我在做一个简单的软件耍，不知道为什么mysql老是报错：
SQL语句：
update peopleresource set gx =’家庭成员’ ,tel = ‘ ‘,fixed_tel = ‘ ‘,e_mail = ‘ ‘,qq = ‘ ‘,area = ‘ ‘,like = ‘ ‘,taboo = ‘ ‘,birthday = ‘ ‘,remarke=’ ‘ where name=’22’
错误反馈：
com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: 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 ‘like = ‘ ‘,taboo = ‘ ‘,birthday = ‘ ‘,remarke=’ ‘ where name=’22” at line 1
数据库的表：
——解决方案——————–
UPDATE peopleresource SET gx =’家庭成员’ ,tel = ‘ ‘,fixed_tel = ‘ ‘,e_mail = ‘ ‘,qq = ‘ ‘
,AREA = ‘ ‘,`LIKE` = ‘ ‘,taboo = ‘ ‘,birthday = ‘ ‘,remarke=’ ‘ WHERE `NAME`=’22’
——解决方案——————–
有保留字加“
——解决方案——————–
关键字最好是不要作为列名啊
一定要加就得加上 键盘1左边的 `
转载请注明原文链接：各位大神看一看吧，这个异常小弟我调一天了。SQL的修改语句
