Mysql 常见错误代码: 1064

来源:互联网 发布:淘宝怎么装修全屏海报 编辑:程序博客网 时间:2024/04/29 12:16



错误提示:

错误代码: 1064
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
原创粉丝点击