update estate.altima_equipment t1 set address =(select name FROM estate.altima_equipment t2 WHERE t1.id =t2.id )WHERE project_id='07dc0bbb4325cb0fbab597dc3694d26d'and equi_type='50';
sql 查询更新update estate.altima_equipment t1 set address = (select name FROM estate.altima_equipment t2 WHERE t1.id =t2.id ) WHERE project_id='07dc0bbb4325cb0fbab597dc3694d26d' and equi_type='50';