日常小记
UPDATE (select t1.function_location_id fl_id1,
t1.tz_name tzname1,
t1.pt_date ptdate1,
t2.pk_id t2_id2,
t2.tz_name tzname2,
t2.pt_date ptdate2
from tab01 t1, tab02 t2
where t1.id = t2.id) t
set t2_id2 = t2_id2, tzname1 = tzname2, ptdate1 = ptdate2;
commit;
