错误代码: 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'
在第一节基础上 更新了函数和执行顺序:实操了字符数函数、时间函数、字段截取函数、interval函数等,除最后顺序实操因未导入数据库,导致无法执行