update a set a.id=(selelct b.id from temp b where b.line = a.line) where a.line = (select line from temp b where b.line = a.line)
转载于:https://www.cnblogs.com/Catherine2011/p/6543979.html
