SH.DevBlog SH.DevBlog

# SelectKey 란? Insert, Update, Delete 전, 후 SELECT가 필요한 경우에 사용하는 MyBatis 문법 # 사용법 UPDATE TBM_EVENT_DTL SET PARTICIPATION_CNT = PARTICIPATION_CNT + 1 WHERE 1=1 AND CP_CD = #{cpCd} AND EVENT_CD = #{eventCd} AND USE_YN = 'Y' AND DEL_YN = 'N' SELECT A.PARTICIPATION_CNT ,A.TOTAL_PART_LIMIT_CNT FROM TBM_EVENT_DTL AS A WHERE 1=1 AND A.CP_CD = #{cpCd} AND A.EVENT_CD = #{eventCd} AND A.USE_YN = 'Y' AND A...