how to Create simple stored procedure which returns resultset in mysql

Question

Create simple stored procedure which returns resultset in mysql

Answer 1

I think this - http://www.mysqltutorial.org/mysql-stored-procedure-tutorial.aspx should help you.

Answer 2

DELIMITER $$

DROP PROCEDURE IF EXISTS `something`.`PName` $$
CREATE PROCEDURE `Something`.`PName` (cid INT)
BEGIN

  SELECT * FROM table;

END $$

DELIMITER ;