mysql> DELIMITER |
mysql> CREATE PROCEDURE emp_test()
-> BEGIN
-> DECLARE x INT;
-> DECLARE y VARCHAR(25);
-> SELECT empno,empname INTO x,y FROM emp LIMIT 1;
-> SELECT x,y;
-> END|
Query OK, 0 rows affected (0.00 sec)

mysql> DELIMITER ;
mysql> CALL emp_test()\G

I think this example help u.....
To know more about it user this link mysql