mysql在update中使用JOIN
UPDATE T1, T2, [INNER JOIN | LEFT JOIN] T1 ON T1.C1 = T2. C1 SET T1.C2 = T2.C2, T2.C3 = expr WHERE condition
注意:本文归作者所有,未经作者允许,不得转载