Snippet: Fetching results after calling stored procedures us
of cursor object is retiring an iterator object which will go over the
results proceeded after calling the stored procedure. Each result is
actually a MySQLCursorBuffered object.
You could also use
with_rows cursor property
to check if the cursor actually could return rows or not (for example,
for SELECT statements). An example is provided in
For this example we create a stored procedure which is
SHOW SLAVE STATUS.
```python cnx = mysql.connector.connect(user=’scott’, password=’tiger’, database=’mining’) cur = cnx.cursor() cur.execute(“DROP PROCEDURE IF EXISTS slave_status”) proc = “CREATE PROCEDURE slave_status () BEGIN SHOW SLAVE STATUS; END” cur.execute() cur.call(“slave_status”)
for result_cursor in cur.stored_results(): for row in result_cursor: print(row) ```
The result from the above would be:
shell $ python foo.py Waiting for master to send event
Using MySQL Connector/Python, you are calling a stored procedure which is also selecting data and you would like to fetch the rows of the result.