网上大多都行不通,这里记录一个可行的。
UPDATE table1 t1,
table2 t2
SET t1.`DRAFTERNAME` = t2.`USERNAME`
WHERE
t1.DRAFTER = t2.ACCOUNT
网上大多都行不通,这里记录一个可行的。
UPDATE table1 t1,
table2 t2
SET t1.`DRAFTERNAME` = t2.`USERNAME`
WHERE
t1.DRAFTER = t2.ACCOUNT