本人在写mysql 存储过程时 :
CREATE DEFINER=`root`@`localhost` PROCEDURE `GetUser_ID`(out userID int,out name varchar(18),in User_Name varchar(30),in Pass_Word varchar(30))
BEGIN
SELECT user_id INTO userID FROM gis_user WHERE user_account = User_Name AND pwd = Pass_Word ;
SELECT user_name INTO name FROM gis_user WHERE user_account = User_Name AND pwd = Pass_Word ;
END
如果
out user_ID int
就会取不到值