mysql> show CREATE PROCEDURE get_user_name\G
*************************** 1. row ***************************
       Procedure: get_user_name
        sql_mode:
Create Procedure: CREATE DEFINER=`root`@`localhost` PROCEDURE `get_user_name`(i char(9))
BEGIN
SELECT * from users where user_name=i;
END
1 row in set (0.02 sec)