Computer Science
A DELETE or UPDATE or INSERT query requires commit() to reflect the changes in the database.
Python MySQL
3 Likes
Answer
True
Reason — We need to run commit() with the connection object for DELETE, UPDATE, or INSERT queries that change the data of the database table, so that the changes are reflected in the database.
Answered By
1 Like
Related Questions
The cursor.rowcount gives the count of records in the resultset.
The cursor.rowcount returns how many rows have been so far retrieved through fetch..() methods from the cursor.
Assertion. A database connection object controls the connection to a database.
Reason. A connection object represents a unique session with a database, connected from within a script/program.
Assertion. A database cursor receives all the records retrieved as per the query.
Reason. A resultset refers to the records in the database cursor and allows processing of individual records in it.