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 = t2.id ) LOOP update table1 set name = c.name where id = c.id; END LOOP; END;
已抢65648个
抢已抢30646个
抢已抢16874个
抢已抢8555个
抢已抢11036个
抢已抢22797个
抢