mysql update join

随手记录一下

UPDATE information f1
LEFT JOIN topic f2 ON f1.id = f2.id
SET f1.img_url = f2.img_url