Mapper.xml에서 오류나는데 확인 좀 해주세요

Question

Column count doesn't match value count at row 1 이렇게 오류 떠서 db랑 매치 잘 시켰는데도 이러네요안 맞는 부분 있나요?INSERT INTO TB_REPORT_ON_MASS_HOLDINGS(STOCK_CODE, CORP_CODE, REG_DATE, MODIFY_DATE, RCEPT_NO, RCEPT_DT, CMPNY_NM, REPORT_TP, REPROR, STKQY, STKQY_IRDS, STKRT, STKRT_IRDS, CTR_STKQY, CTR_STKRT, REPORT_RESN) VALUES (#{stock_code}, #{corp_code}, #{regDate}, #{modifyDate}, #{rcept_no}, #{rcept_dt}, #{cmpny_nm}, #{report_tp}, #{repror}, #{stkqy}, #{stkqy_irds}, #{stkrt}, #{stkrt_irds}, #{ctr_stkqy}, #{ctr_stkrt}, #{report_resn}) ON DUPLICATE KEY UPDATE STOCK_CODE &#61; #{stock_code}, CORP_CODE &#61; #{corp_code}, REG_DATE &#61; #{regDate}, MODIFY_DATE &#61; #{modifyDate}, RCEPT_NO &#61; #{rcept_no}, RCEPT_DT &#61; #{rcept_dt}, CMPNY_NM &#61; #{cmpny_nm}, REPORT_TP &#61; #{report_tp}, REPROR &#61; #{repror}, STKQY &#61; #{stkqy}, STKQY_IRDS &#61; #{stkqy_irds}, STKRT &#61; #{stkrt}, STKRT_IRDS &#61; #{stkrt_irds}, CTR_STKQY &#61; #{ctr_stkqy}, CTR_STKRT &#61; #{ctr_stkrt}, REPORT_RESN &#61; #{report_resn}

Mapper.xml에서 오류나는데 확인 좀 해주세요

0개의 답변

#mabatis 목록