mybaits batch update (MySQL verified)

The first way

Update id= "UpdateBatch" parametertype= "Map" >
Update AA Set
A=#{FPTM},
B=#{csoftrain}
where C in
<foreach collection= "CS" index= "index" item= "Item" pen= "(" separator= "," close= ")" >
#{item}
</foreach>
</update>

But the values of the fields that are modified in this way are the same.

The second way

Note If you want to modify the database connection, the UPDATE statement will error, verified. ）

Modify database Connection configuration: &allowmultiqueries=true

For example: jdbc:mysql://192.168.1.236:3306/test?useunicode=true&amp;characterencoding=utf-8&allowmultiqueries= True

<update id= "BatchUpdate" parametertype= "Java.util.List" >

<foreach collection= "List" item= "item" index= "index" open= "" close= "" separator= ";" >
Update test
<set>
Test=${item.test}+1
</set>
WHERE id = ${item.id}
</foreach>

</update>