sqle
sqle copied to clipboard
MYABITS UPDATE SET 多字段时 带逗号和不带逗号 解析错误
SQLe Version 1.2209.0
<update id="update" parameterType="com.easternunion.merchant.pojo.MerchantAccountHistory">
update merchant_account_stream
<set>
<if test="merchantAccountId != null">`merchant_account_id` = #{merchantAccountId}, </if>
<if test="merchantNo != null">`merchant_no` = #{merchantNo}, </if>
<if test="amount != null">`amount` = #{amount}, </if>
<if test="type != null">`type` = #{type}, </if>
<if test="flowNo != null">`flow_no` = #{flowNo}, </if>
<if test="operatorId != null">`operator_Id` = #{operatorId}, </if>
<if test="createTime != null">`create_time` = #{createTime}, </if>
<if test="lastUpdateTime != null">`last_update_time` = #{lastUpdateTime}</if>
<if test="beforeAmount != null">`before_amount` = #{beforeAmount}</if>
<if test="afterAmount != null">`after_amount` = #{afterAmount}</if>
<if test="unsettleAmount != null">`unsettle_amount` = #{unsettleAmount}</if>
</set>
where Id = #{id}
</update>
| warn语法错误或者解析器不支持,请人工确认SQL正确性 | update merchant_account_stream SET merchant_account_id = ?, merchant_no = ?, amount = ?, type = ?, flow_no = ?, operator_Id = ?, create_time = ?, last_update_time = ?before_amount = ?after_amount = ?unsettle_amount = ? where Id = ? ; |
|---|