各位大神看一看吧,这个异常小弟我调一天了。SQL的修改语句

各位大神看一看吧,这个错误我调一天了。。。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的修改语句

相关文章:

你感兴趣的文章:

标签云: