DB/MySQL
SELECT UPDATE
풍풍
2011. 6. 30. 14:59
UPDATE table1 AS a
SET col1=(SELECT col1 FROM table2 AS b WHERE a.col2 = b.col2)