Mysql修改从别的表或者自己表复制字段更新

update stu_info s join (select id,family_address from stu_info) a on s.id = a.id
set s.remark = a.family_address where 1=1

update pos_plu p join (select hotelid , sort,seq from pos_sort) as s on p.sort = s.sort and p.hotelid = s.hotelid
set p.seq = s.seq where p.hotelid = 'H000014'