[multi update] mysql 다중 수정

쿼리문 예제)

UPDATE TABLE

SET

name = CASE

WHEN id = 1 THEN "lion"

WHEN id = 2 THEN "cat"

END

WHERE

name IN (1, 2)

아이바티스 예제)

<update id="modifyOrdering" parameterClass="java.util.List">

<![CDATA[

UPDATE ADMINBOARD

SET

KEYVISUAL_ORDER = CASE

]]>

<iterate conjunction=" ">

WHEN seq=#[].seqId#  THEN #[].keyviOrder# 

</iterate>

<![CDATA[

END

WHERE

KEYVISUAL_ORDER IN (1, 2, 3, 4, 5, 6);

]]>

</update>