MySQL Connector/Python Release Notes
Syntax:
Press CTRL+C to copycnx.cmd_query_iter(statement)
Similar to the
cmd_query()
method, but returns a generator object to iterate through
results. Use cmd_query_iter()
when sending
multiple statements, and separate the statements with
semicolons.
The following example shows how to iterate through the results after sending multiple statements:
Press CTRL+C to copystatement = 'SELECT 1; INSERT INTO t1 VALUES (); SELECT 2' for result in cnx.cmd_query_iter(statement): if 'columns' in result: columns = result['columns'] rows = cnx.get_rows() else: # do something useful with INSERT result
Returns a generator object.