FINAL PROJECT
[API -> DB] insert 시행착오겪는 중...
asso
2022. 8. 11. 03:46
insert into go_api ( facltNm, addr1, addr2, induty, firstImageUrl, contentId, intro, animalCmgCl, trlerAcmpnyAt, caravAcmpnyAt, lctCl, brazierCl, siteBottomCl1, siteBottomCl2, siteBottomCl3, siteBottomCl4, siteBottomCl5, sbrsCl, doNm, eqpmnLendCl, homepage, mapX, mapY ) select ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? from dual where not exists ( select facltNm from go_api where facltNm=? );


정말 중복 없이만 insert 되느라 딱 하나만 저장되는......