联动更新:

UPDATE A INNER JOIN B ON A.id=B.id SET A.info = B.info;