mysql join update sample
update
stock_day_chart a
inner join stock_day_chart_backup b
on
(a.stock_cd = b.stock_cd
and a.stock_date = b.stock_date)
set
a.std_prc = b.std_prc ,
a.close_per = b.close_per ,
a.high_per = b.high_per,
a.fvrt_yn = b.fvrt_yn
where
b.std_prc is not null
728x90
댓글