sql 语句:
update a set a.reference=cid from custom a inner join
(select b.id as cid,b.phone as phone from custom as b ) con a.reference=c.phone
sql 语句:
update a set a.reference=cid from custom a inner join
(select b.id as cid,b.phone as phone from custom as b ) c