A表: aid adate B表: bid bdate UPDATE A a SET a.`adate` = (SELECT b.`bdate` FROM B b WHERE b.`bid`= a.`aid`) WHERE a.`aid` IN (SELECT b.`bid` FROM B b);