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;
结果: