get records from procedure having multiple select statements in mysql

Question

I have created a procedure in mysql having multiple select statements in it.

Here is my code :

DELIMITER $$

USE `databasename`$$

DROP PROCEDURE IF EXISTS `wholeProjectDetails`$$

CREATE DEFINER=`databasename`@`localhost` PROCEDURE `wholeProjectDetails`(IN givenpid INT)
BEGIN
select * from projects where projectid=givenpid;
select * from projects where projectid<>givenpid;
END$$

DELIMITER ;

When i called this procedure using statement :

call wholeProjectDetails(2);

it is displaying only first statement's results, i want that it will display both statement's records.

Please let me know what i am doing wrong?

Thanks

If 'PHP' then, follow [*this answer*](http://stackoverflow.com/a/1686047/767881) — Ravinder Reddy, Jun 16 '14 at 06:18

score 0 · Answer 1 · answered Jun 16 '14 at 08:29

When you call this procedure, MySQL creates two result-sets. Now, you need to get these two result-sets using your MySQL client. Read information about client you use, does it support this feature? For example, in .NET you can use IDataReader.NextResult Method, in mysqli - mysqli::next_result function, and so on.

If you want just to view these result-sets, you can install one of MySQL GUI tools, there are free ones.

get records from procedure having multiple select statements in mysql

1 Answers1