How can two updates be executed together in MyBatis?

In MyBatis, multiple update statements can be executed together using the tag. Here is an example:

<update id="updateBatch" parameterType="java.util.List">
  <foreach collection="list" item="item" separator=";">
    update your_table set column1 = #{item.column1}, column2 = #{item.column2} where id = #{item.id}
  </foreach>
</update>

In this example, updateBatch is an update statement that takes a List parameter. By utilizing the tag, it iterates through each element in the List and sets the attribute values of each element into the corresponding parameters of the update statement. Using separator=”;” indicates that a semicolon will be used to separate each update statement.

After that, you can use this update statement to perform multiple update operations by passing a List containing multiple objects as parameters, with each object containing the column to be updated and its corresponding value.

Please note that the update statement in the above example is just for demonstration purposes. You will need to modify the table name, column names, and conditions based on your actual situation.