worth knowin

MySQL select into

The syntax for MySQL's SELECT INTO is in reverse:

INSERT INTO table (field) SELECT s.key FROM other_table s;

Good for making up temp tables.

• http://dev.mysql.com/doc/refman/5.1/en/ansi-diff-select-into-table.html

Posted 13 Aug 2007, tagged with mysql sql