--将SH的优惠券类型参数复制给新开通的城市HD市
INSERT
INTO
TBL_CHMGM_DIVISION_PARA_RELATED_INF
(
SEQ_ID,
MCHNT_PARA_ID,
PROV_DIVISION_CD,
CITY_DIVISION_CD
)
SELECT
NEXT value FOR SEQ_CHMGM_DIVISION_PARA_RELATED_INF,
b.MCHNT_PARA_ID,
'130000',
'130400'
FROM
(
SELECT
MCHNT_PARA_ID
FROM
TBL_CHMGM_DIVISION_PARA_RELATED_INF
WHERE
PROV_DIVISION_CD ='310000')b
DB2插入SQL备份
最新推荐文章于 2022-05-06 20:58:25 发布