MySQL Connector/Python Release Notes
Deprecation
This method has been deprecated as of 9.3.0.
Syntax:
Press CTRL+C to copyiterator = cursor.stored_results()
This method returns a list iterator object that can be used to process result sets produced by a stored procedure executed using the callproc() method. The result sets remain available until you use the cursor to execute another operation or call another stored procedure.
The following example executes a stored procedure that produces
two result sets, then uses stored_results()
to retrieve them:
Press CTRL+C to copy>>> cursor.callproc('myproc') () >>> for result in cursor.stored_results(): ... print result.fetchall() ... [(1,)] [(2,)]