MySQL 1064 错误

来源:互联网 发布:程序员转行能干什么 编辑:程序博客网 时间:2024/06/08 20:11

错误提示:You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ‘issplit = ‘1’ where term = ‘00” at line 1

原来的sql语句:
UPDATE tag SET msplit = ‘00’ issplit = ‘1’ WHERE term = ‘00’

经过检查之后发现时sql 语句写错了。
应该修改为:
UPDATE tag SET msplit = ‘00’ ,issplit = ‘1’ WHERE term = ‘00’

0 0
原创粉丝点击