create table fatliver3
as
SELECT id, drink, smoking, CASE WHEN DRINK like '음주많음'
and SMOKING like '흡연'
THEN 1
ELSE 0
END AS smoke_drink
FROM fatliver2;
MERGE
merge into fatliver2 a
using fatliver3 b
on (a.id = b.id)
when matched then
update set a.smoke_drink = b.smoke_drink;
UPDATE
update fatliver2 a
set a.smoke_drink = (select b.smoke_drink
from fatliver3 b
where a.id = b.id);
select * from fatliver2;