Classe « MySQLConnection »

Méthode mysql.connector.MySQLConnection.cmd_query_iter

Signature de la méthode cmd_query_iter

def cmd_query_iter(self, statements) 

Description

cmd_query_iter.__doc__

Send one or more statements to the MySQL server

        Similar to the cmd_query method, but instead returns a generator
        object to iterate through results. It sends the statements to the
        MySQL server and through the iterator you can get the results.

        statement = 'SELECT 1; INSERT INTO t1 VALUES (); SELECT 2'
        for result in cnx.cmd_query(statement, iterate=True):
            if 'columns' in result:
                columns = result['columns']
                rows = cnx.get_rows()
            else:
                # do something useful with INSERT result

        Returns a generator.