When is cursor execute

In the preceding example, the datetime. If multi is set to True , execute is able to execute multiple statements specified in the operation string. It returns an iterator that enables processing the result of each statement.

However, using parameters does not work well in this case, and it is usually a good idea to execute each statement on its own. The following example selects and inserts data in a single execute operation and displays the result of each statement:.

If the connection is configured to fetch warnings, warnings generated by the operation are available through the MySQLCursor. Guidelines for Python Developers. Line The fetchall method fetches all the remaining records from the result sets. Line The fetchmany has default size 1, so it again tries to fetch one record from the result sets. But as the fetchmany 4 method already access the 4 records and fetchone method access the 1st record, so it tries to fetch the 6th tuple from the record sets.

The syntax of the executemany function is:. We can also execute multiple queries using the single execute function. The execute function accepts one extra parameter, multi. Line We pass the list of queries, val and separator ; to the execute method.

We also change the value of multi from False to True. In this article, we studied the execute method. In the preceding example, the datetime. If multi is set to True , execute is able to execute multiple statements specified in the operation string. It returns an iterator that enables processing the result of each statement. Programmers are allowed to create named context area to execute their DML operations to get more control over it.

The name of this context area is same as the cursor name. It will make the cursor ready to fetch the records. These are now called as active sets. Fetching data from the cursor is a record-level activity that means we can access the data in a record-by-record way. Each fetch statement will fetch one active set and holds the information of that particular record. Once all the record is fetched now, we need to close the cursor so that the memory allocated to this context area will be released.

Both Implicit cursor and the explicit cursor has certain attributes that can be accessed. These attributes give more information about the cursor operations.