SELECT [ ALL | DISTINCT [ ON ( expression [, ...] ) ] ] expression [ AS name ] [, ...] [ INTO [ TEMPORARY | TEMP ] [ TABLE ] new_table ] [ FROM table [ alias ] [, ...] ] [ WHERE condition ] [ GROUP BY column [, ...] ] [ HAVING condition [, ...] ] [ { UNION [ ALL ] | INTERSECT | EXCEPT } select ] [ ORDER BY column [ ASC | DESC | USING operator ] [, ...] ] [ FOR UPDATE [ OF class_name [, ...] ] ] LIMIT { count | ALL } [ { OFFSET | , } start ]
SELECT INTO は問い合わせの結果から新し いテーブルを作成します。 通常、この問い合わせは既存のテーブルからデータを引き出す ものになりますが、どのような SQL 問い合わせでも使用できま す。
Note: CREATE TABLE AS は機能的には SELECT INTO コマンド と同一です。