[SQL] 다중 INSERT

 

sql

--다중 insert
INSERT ALL
INTO ITEM_ATTACH(FULLNAME, ITEM_ID, REGDATE) VALUES('개똥이.jpg',1,sysdate)
INTO ITEM_ATTACH(FULLNAME, ITEM_ID, REGDATE) VALUES('개똥이2.jpg',1,sysdate)
INTO ITEM_ATTACH(FULLNAME, ITEM_ID, REGDATE) VALUES('개똥이3.jpg',1,sysdate)
SELECT * FROM DUAL;
COMMIT;

 

 

 

maper.xml에서

<!-- 파일 다중 입력
List<ItemAttachVO> itemAttachVOList
 -->
<update id="registMultiAttach" parameterType="java.util.List">
<foreach collection="list" item="itemAttachVO"
open="INSERT ALL" close="SELECT * FROM DUAL" separator=" " index="idx">
INTO ITEM_ATTACH(FULLNAME, ITEM_ID, REGDATE)
VALUES(#{itemAttachVO.fullname},#{itemAttachVO.itemId},sysdate)
</foreach>
</update>