pooney

insert into
testdb.testsub(
sub_idx,
parent_idx,
sub_keyword
)
values
<foreach collection="list" separator="," item="item">
(#{item.subIdx}, #{item.mainIdx},#{item.subKeyWord})
</foreach>
ON DUPLICATE KEY
UPDATE sub_keyword=VALUES(sub_keyword);

profile

pooney

@pooney

포스팅이 좋았다면 "좋아요❤️" 또는 "구독👍🏻" 해주세요!