不使用游标，多张表的多条记录更新:BEGINFOR c IN (select distinct t2.name,t1.idfrom table1 t1,table2 t2where t1.id = t2.id)LOOPupdate table1 set name = c.name where id = c.id;END LOOP;END; BEGIN FOR c IN ( select distinct t2.name,t1.id from table1 t1, table2 t2 where t1.id