Devlog

I forget this every time.

1. Select and Insert

INSERT INTO
	table1 ( table1.column1, table1.column2 )
SELECT
	table2.code, table2.name
FROM
	table2;

2. Select and Update (actually, JOIN UPDATE)

UPDATE
	table1, table2
SET
    table1.column1 = table2.column1
WHERE
	table1.column_key = table2.column_key;

Reference:

http://entireboy.egloos.com/4657692