update PMS.tenant_contract a inner join(select id,home_id from PMS.owner_contract) c on a.id = c.id set a.house_id = c.home_id;
update PMS.tenant_contract a inner join(select id,home_id from PMS.owner_contract) c on a.id = c.id set a.house_id = c.home_id;
转载于:https://www.cnblogs.com/canyangfeixue/p/9958451.html