mysql存储过程调用含out参数

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

CREATE DEFINER=`root`@`localhost` PROCEDURE `hovertreeTest`( IN `Param1` INT, IN `Param2` VARCHAR(50), OUT `Param3` INT)LANGUAGE SQLNOT DETERMINISTICCONTAINS SQLSQL SECURITY DEFINERCOMMENT 测试BEGINselect param1;select param2;set Param3 = 6;END

调用该存储过程的代码:

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

结果:

相关文章