MySQL错误1093 - 无法在FROM子句中指定更新的目标表

UPDATE table1
SET column1 = (SELECT column2 FROM table2 WHERE table2.id = table1.id);

UPDATE table1
JOIN table2 ON table1.id = table2.id
SET table1.column1 = table2.column2;

CREATE TEMPORARY TABLE temp_table
SELECT column1, column2 FROM table1;

UPDATE table1
SET column1 = (SELECT column2 FROM temp_table WHERE temp_table.id = table1.id);

DROP TEMPORARY TABLE temp_table;