mysql insert 替换值_mysql 插入replace改变原有数据某些字段

最新推荐文章于 2022-03-26 10:42:56 发布

忘了带枪

最新推荐文章于 2022-03-26 10:42:56 发布

阅读量329

点赞数

文章标签： mysql insert 替换值

本文链接：https://blog.csdn.net/weixin_34515452/article/details/113239712

版权

完整原型：(主要看下面例子)

replace into rpt_ci_cinema_seller_shift_dt ( BIZ_DATE,CINEMA_CD,SELLER_CD,LOCATION_CD,SHIFT_DATETIME,TOTAL_EARNING_AMT,TOTAL_CASH,PETTY_CASH,TURN_IN_CASH,TICKET_TOTAL,TICKET_CASH,REFUND_AMT,ISSUE_CARD_TOTAL,ISSUE_CARD_CASH,ISSUE_CARD_CREDIT,ISSUE_CARD_CHEQUE,ISSUE_CARD_ALIPAY,ISSUE_CARD_WECHAT,ISSUE_CARD_DEBT,ADDMONEY_TOTAL,ADDMONEY_CASH,ADDMONEY_CREDIT,ADDMONEY_CHEQUE,ADDMONEY_ALIPAY,ADDMONEY_WECHAT,ADDMONEY_DEBT,ADDMONEY_DONATE,MEMBCARD_TICKET_NUM,CREDIT_INCOME,CHEQUE_INCOME,TICKET_DEBT_INCOME,PREPAY_INCOME,COLLECTION_INCOME,UNIONPAY_INCOME,THIRD_INCOME,ALIPAY_INCOME,WECHAT_INCOME,VOUCHER_AMT,GIFT_SWAP_AMT,CASH_VOUCHER_AMT,REFUND_THIRD_TICKET,SWAP_INTEGRAL,REFUND_INTEGRAL,CONFERENCE_AMT,CINEMA_INCOME ) select '20160729' AS BIZDATE,CINEMA_CD,SELLER_CD,LOCATION_CD,SHIFT_DATETIME,TOTAL_EARNING_AMT,TOTAL_CASH,PETTY_CASH,TURN_IN_CASH,TICKET_TOTAL,TICKET_CASH,REFUND_AMT,ISSUE_CARD_TOTAL,ISSUE_CARD_CASH,ISSUE_CARD_CREDIT,ISSUE_CARD_CHEQUE,ISSUE_CARD_ALIPAY,ISSUE_CARD_WECHAT,ISSUE_CARD_DEBT,ADDMONEY_TOTAL,ADDMONEY_CASH,ADDMONEY_CREDIT,ADDMONEY_CHEQUE,ADDMONEY_ALIPAY,ADDMONEY_WECHAT,ADDMONEY_DEBT,ADDMONEY_DONATE,MEMBCARD_TICKET_NUM,CREDIT_INCOME,CHEQUE_INCOME,TICKET_DEBT_INCOME,PREPAY_INCOME,COLLECTION_INCOME,UNIONPAY_INCOME,THIRD_INCOME,ALIPAY_INCOME,WECHAT_INCOME,VOUCHER_AMT,GIFT_SWAP_AMT,CASH_VOUCHER_AMT,REFUND_THIRD_TICKET,SWAP_INTEGRAL,REFUND_INTEGRAL,CONFERENCE_AMT,CINEMA_INCOME from rpt_ci_cinema_seller_shift_dt where biz_date='20160725' ;

INSERT INTO RPT_TR_CINEMA_TICKET_TRADE_DETAIL(

ID,

TRADE_DATE,

SCINEMA_CD,

OPT_TYPE,

TRADE_CHANL,

FILM_CD,

HALL_CD,

CINEMA_NAME,

FILM_NAME,

SHOW_DATE,

SHOW_TIME,

TICKET_TYPE,

TICKET_GROUP,

BOOKING_ID,

TICKET_NO,

SEQ_NO,

ROW_ID,

COL_ID,

PAYMENT_SEQ,

PAYMENT_TYPE,

PAYMENT_AMT,

PAYMENT_NUM,

TICKET_AMT,

MEMBCARD_NO,

COUPON_TYPE,

SESSION_CODE,

THROUGH_FLG,

OPTER_ID,

OPTER,

REFUND_REASON_DESC,

CRT_DATETIME,

IS_RETURN)

select

REPLACE(uuid(),'-',''),