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 (), '-', '),
Trade_date,
",--in-theatre yards
Opt_type,
TRADE_CHANL,
FILM_CD,
HALL_CD,
' As Cinema_name,--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
From Rpt_tr_cinema_ticket_trade_detail
Where scinema_cd= ' 1843 '
MySQL Insert replace change existing data some fields