Writing mysql stored procedures and functions

Mysql stored procedure and function writing stored PROCEDURE 01 drop procedure if exists temp; 02 delimiter // 03 create procedure temp () 04BEGIN05 declare V_RETUR int; 06 www.2cto.com begin07 if exists (SELECT 1 FROM dual where 1 = 1) then08 IF 1 = 1 then09 set V_RETUR = 1; 10 select V_RETUR; 11 END if; 12 END if; 13 end; 14END // 15 16 17 call temp (); function 1 drop FUNCTION if exists hello; 2 www.2cto.com delimiter // 3 CREATE function hello (s CHAR (20) 4 RETURNS CHAR (50) 5begin6 return concat ('hello, ', s ,'! '); 7end // 8 9 select hello ('admin'); author leaves flowers