INTO TEMP 子句

通过将 INTO TEMP 子句添加到您的 SELECT 语句，可以在独立的表中临时保存多表查询的结果，您可以查询或处理该表，而无需修改数据库。当结束 SQL 会话或者程序或报告终止时，就会删除临时表。

下列查询创建名为 stockman 的临时表，并将在其中保存查询的结果。由于临时表中的所有列都必须具有名称，所以别名 adj_price 是必需的。

图: 查询

SELECT DISTINCT stock_num, manu_name, description, 
          unit_price, unit_price * 1.05  adj_price
          FROM stock, manufact
          WHERE manufact.manu_code = stock.manu_code
          INTO TEMP stockman;
          SELECT * from stockman;

图: 查询结果

stock_num manu_name       description     unit_price   adj_price
            
            1 Hero            baseball gloves    $250.00    $262.5000
            1 Husky           baseball gloves    $800.00    $840.0000
            1 Smith           baseball gloves    $450.00    $472.5000
            2 Hero            baseball           $126.00    $132.3000
            3 Husky           baseball bat       $240.00    $252.0000
            4 Hero            football           $480.00    $504.0000
            4 Husky           football           $960.00   $1008.0000
            ⋮
            306 Shimara         tandem adapter     $190.00    $199.5000
            307 ProCycle        infant jogger      $250.00    $262.5000
            308 ProCycle        twin jogger        $280.00    $294.0000
            309 Hero            ear drops           $40.00     $42.0000
            309 Shimara         ear drops           $40.00     $42.0000
            310 Anza            kick board          $84.00     $88.2000
            310 Shimara         kick board          $80.00     $84.0000
            311 Shimara         water gloves        $48.00     $50.4000
            312 Hero            racer goggles       $72.00     $75.6000
            312 Shimara         racer goggles       $96.00    $100.8000
            313 Anza            swim cap            $60.00     $63.0000
            313 Shimara         swim cap            $72.00     $75.6000

可以查询此表并将该表与其它表连接，这可以避免多次排序，并使您能够更快地在数据库中移动。有关临时表的更多信息，请参阅 GBase 8s SQL 指南：语法和 GBase 8s 管理员指南。