- INSERT INTO yy_marketing_coupon
- (
- uuid,
- no,
- name,
- type,
- money,
- status,
- instruction,
- astrict,
- total_number,
- remain_number,
- send_mode,
- get_mode,
- use_mode,
- user_rank_lower,
- send_start_time,
- send_end_time,
- use_start_time,
- use_end_time,
- use_expire_time,
- discount,
- user_mobiles,
- create_time,
- creater,
- update_time,
- updater,
- appid,
- use_car_type,
- highest_money,
- term_type,
- coupon_template_uuid,
- gift_uuid,
- city_uuids,
- city_names
- )
- VALUES
- <foreach collection="list" item="item" index="index" separator=",">
- (
- #{item.uuid},
- (select FN_CREATE_COUPON_NO(1)),
- #{item.name},
- #{item.type},
- #{item.money},
- #{item.status},
- #{item.instruction},
- #{item.astrict},
- #{item.totalNumber},
- #{item.remainNumber},
- #{item.sendMode},
- #{item.getMode},
- #{item.useMode},
- #{item.userRankLower},
- #{item.sendStartTime},
- #{item.sendEndTime},
- #{item.useStartTime},
- #{item.useEndTime},
- #{item.useExpireTime},
- #{item.discount},
- #{item.userMobiles},
- #{item.createTime},
- #{item.creater},
- #{item.updateTime},
- #{item.updater},
- #{item.appid},
- #{item.useCarType},
- #{item.highestMoney},
- #{item.termType},
- #{item.couponTemplateUuid},
- #{item.giftUuid},
- #{item.cityUuids},
- #{item.cityNames}
- )
- </foreach>
来源: https://www.cnblogs.com/jmcui/p/9233427.html