mysql存储过程调用含out参数

mysql 数据库有以下存储过程:

CREATE DEFINER=`root`@`localhost` PROCEDURE `hovertreeTest`(
    IN `Param1` INT,
    IN `Param2` VARCHAR(50),
    OUT `Param3` INT

)
LANGUAGE SQL
NOT DETERMINISTIC
CONTAINS SQL
SQL SECURITY DEFINER
COMMENT '测试'
BEGIN

select param1;
select param2;
set Param3 = 6;

END

调用该存储过程的代码:

CALL `hovertreeTest`('9', 'hovertree',@hvt);
select @hvt;

结果:

posted on 2018-10-29 22:10  活灵活现  阅读(952)  评论(0编辑  收藏  举报

导航