Avinash Mohite
Hi
MySQL stored procedure how to return multiple result set
It is very simple, write SELECT several times in the body of the procedure. All will be sent to the client.
Those SELECTs that have only variables as it target in the select list go to the procedure, those SELECTs that don't have variables in the select list go to the client.