MySQL 返回参数和返回结果集
在MySQL存储过程中,可不可以同时有返回参数和返回结果集 我试了很多次用C++ 或 JAVA 获取 都是只能返回一种
比如存储过程:
DELIMITER $$
DROP PROCEDURE IF EXISTS SP_queryCount $$
CREATE SP_queryCount (IN iCounts INT,OUT iNum INT)
BEGIN
SET @tmpCounts = iCounts ;
SET @tmpNum = 0 ;
SET @tureccmd = CONCAT('SELECT p_actorid FROM actor_a LIMIT ? ');
PREPARE stmt FROM @tureccmd ;
EXECUTE stmt USING @tmpCounts ; /*运行获得结果集*/
DEALLOCATE PREPARE stmt ;
SET @tureccmd = CONCAT('SELECT COUNT(p_actorid) INTO @tmpNum FROM actor_a WHERE p_actorid = ? ');
PREPARE stmt FROM @tureccmd ;
EXECUTE stmt USING @tmpCounts ;
DEALLOCATE PREPARE stmt ;
SET iNum = @tmpNum ; /*运行参数获得返回数据iNum值*/
END$$
DELIMITER ;
如何 能获得iNum 的值 也可以 得结果集的值呢