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