INSERT INTO `km_product_order` SET uid = #{uid}, ordCount = #{ordCount}, ordPrice = #{ordPrice}, ordDiscount = #{ordDiscount}, ordDelivery = #{ordDelivery}, savePoint = #{savePoint}, usedPoint = #{usedPoint}, ordTotPrice = #{ordTotPrice}, recipName = #{recipName}, recipHp = #{recipHp}, recipZip = #{recipZip}, recipAddr1 = #{recipAddr1}, recipAddr2 = #{recipAddr2}, ordPayment = #{ordPayment}, ordComplete = '1', ordDate = NOW(); "> INSERT INTO `km_product_order` SET uid = #{uid}, ordCount = #{ordCount}, ordPrice = #{ordPrice}, ordDiscount = #{ordDiscount}, ordDelivery = #{ordDelivery}, savePoint = #{savePoint}, usedPoint = #{usedPoint}, ordTotPrice = #{ordTotPrice}, recipName = #{recipName}, recipHp = #{recipHp}, recipZip = #{recipZip}, recipAddr1 = #{recipAddr1}, recipAddr2 = #{recipAddr2}, ordPayment = #{ordPayment}, ordComplete = '1', ordDate = NOW(); "> INSERT INTO `km_product_order` SET uid = #{uid}, ordCount = #{ordCount}, ordPrice = #{ordPrice}, ordDiscount = #{ordDiscount}, ordDelivery = #{ordDelivery}, savePoint = #{savePoint}, usedPoint = #{usedPoint}, ordTotPrice = #{ordTotPrice}, recipName = #{recipName}, recipHp = #{recipHp}, recipZip = #{recipZip}, recipAddr1 = #{recipAddr1}, recipAddr2 = #{recipAddr2}, ordPayment = #{ordPayment}, ordComplete = '1', ordDate = NOW(); ">
<insert id="insertOrder" useGeneratedKeys="true" keyColumn="ordNo" keyProperty="ordNo">
INSERT INTO `km_product_order` SET
uid = #{uid},
ordCount = #{ordCount},
ordPrice = #{ordPrice},
ordDiscount = #{ordDiscount},
ordDelivery = #{ordDelivery},
savePoint = #{savePoint},
usedPoint = #{usedPoint},
ordTotPrice = #{ordTotPrice},
recipName = #{recipName},
recipHp = #{recipHp},
recipZip = #{recipZip},
recipAddr1 = #{recipAddr1},
recipAddr2 = #{recipAddr2},
ordPayment = #{ordPayment},
ordComplete = '1',
ordDate = NOW();
</insert>
https://myeongdev.tistory.com/38
https://velog.io/@jiu_lee/MyBatis-InsertUpdate-후-PK-값-return