无崖子 2018-10-23
DELIMITER // CREATE PROCEDURE save_get_donator(IN p_in int,INOUT p_inout int,OUT p_out int) BEGIN SELECT @p_in,@p_inout, @p_out; SET p_in = 1; SET p_inout = 3; SET p_out = 5; END; // DELIMITER ; #调用 SET @p_in=0; SET @p_inout=-3; SET @p_out=-5; CALL save_get_donator(@p_in,@p_inout,@p_out) ; SELECT @p_in,@p_inout, @p_out;