mysql join update sample

 

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