UPDATE A a
LEFT JOIN B b ON a.x = b.x
SET
a.a1 = b.b1,
a.a2 = b.b2
WHERE
a.a3 = xxx
转载于:https://my.oschina.net/u/817904/blog/547404
UPDATE A a
LEFT JOIN B b ON a.x = b.x
SET
a.a1 = b.b1,
a.a2 = b.b2
WHERE
a.a3 = xxx
转载于:https://my.oschina.net/u/817904/blog/547404