MySqlのストアド・プロシージャの練習

#           
CREATE FUNCTION f2(num1 SMALLINT UNSIGNED,num2 SMALLINT UNSIGNED) returns FLOAT(8,2)
return (num1+num2)/2;
#    
select f2(10,15);
#            
create function f1() RETURNS VARCHAR(30)
return DATE_FORMAT(now(),'%Y %m %d ');
select f1();
#           
create PROCEDURE sp1() select version();
#           
call sp1();
#         
#delimiter mysql     ，      
delimiter //
create PROCEDURE removeUserById(IN UID INT UNSIGNED)
BEGIN
DELETE FROM USERS WHERE ID=UID;
END
//
DELIMITER;
#    IN,OUT        
delimiter //
create procedure removeUserIdAndReturnNums(IN UID INT UNSIGNED,OUT NUMS INT UNSIGNED)
BEGIN
DELETE FROM USERS WHERE ID=UID ;
SELECT COUNT(ID) FROM USERS INTO NUMS;
END
//
DELIMITER ;
#      
call removeUserIdAndReturnNums(32,@nums);
select @nums;