How to create a procedure in MySQL

--
-- Definition of procedure `sp_eventuser_insert`
--

DROP PROCEDURE IF EXISTS `sp_eventuser_insert`;

DELIMITER $$

/*!50003 SET @TEMP_SQL_MODE=@@SQL_MODE, SQL_MODE='STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER' */ $$
CREATE DEFINER=`root`@`localhost` PROCEDURE `sp_eventuser_insert`(
in _UID bigint,
in _EID bigint,
in _Name varchar(100),
in _Description varchar(300)
)
BEGIN

Insert into eventuser
(
Name ,
Description,
UID ,
EID,
GUID,
InsertTimeStamp
) values(
_Name ,
_Description,
_UID ,
_EID,
UUID(),
NOW()
);

SELECT @@IDENTITY;

END $$
/*!50003 SET SESSION SQL_MODE=@TEMP_SQL_MODE */ $$

DELIMITER ;