SELECT INTO
名稱
SELECT INTO 從當前表或視圖中創建一個新表
語法
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 中有詳細描述．
輸出
所有輸入的域都在 SELECT 中有詳細描述．
描述
SELECT INTO 從一個查詢中創建一個新表．比較典型的是這個查詢從一個現存的表中提取數據，但實際上任何 SQL 查詢都可以．
注意：CREATE TABLE AS 功能上和 SELECT INTO 命令相等．
(http://www.fanqiang.com)
進入【UNIX論壇】
|
![[ 永遠的UNIX::UNIX技術資料的寶庫 ]](/images/title.gif)