GBase 8s 存储过程解析之SELECT...INTO...

语法格式：

SELECT col_name[,...] INTO var_name[,...] table_expr

功能：

将选出的列存储到变量中。只有单一行的结果才可以被取回。

示例1：SELECT intX INTO @intResult;

gbase> DELIMITER //

gbase> DROP PROCEDURE IF EXISTS doselect_into //

Query OK, 0 rows affected

gbase> CREATE PROCEDURE doselect_into (p1 INT)

     BEGIN

     DECLARE intX INT;

     SET intX = 0;

     REPEAT SET intX = intX + 1; UNTIL intX > p1 END REPEAT;

     SELECT intX INTO @intResult;

     SELECT @intResult;

     END //

Query OK, 0 rows affected

gbase> DELIMITER ;

gbase> CALL doselect_into (1000);

+------------+

| @intResult |

+------------+

|       1001 |

+------------+

1 row in set 

Query OK, 0 rows affected