mybatis sql错误语句
你珂哥 2019-10-16 03:16:41 <!-- 批量更新 -->
<update id="updateAll" parameterType="java.util.List">
<foreach item="item" index="index" collection="list" separator=";" >
update sys_settings
set SETTINGS_VALUE = #{item.value}
where SETTINGS_KEY = #{item.key}
</foreach>
</update>
运行报错
### Error updating database. Cause: com.mysql.jdbc.exceptions.jdbc4.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 'update sys_settings
set SETTINGS_VALUE = '60667'
where SETTINGS_KEY = 'Int' at line 5
---------------------------------------------------------------
就语法错误,请教一下错误在哪里