Q. Explain the transaction keywords used with MySQL-Python connectivity.


Answer =


(i) commit :- MySQLConnection.commit() method sends a COMMIT statement to the MySQL server, committing the current transaction.


(ii) rollback :- MySQLConnection.rollback reverts the changes made by the current transaction.


(iii) autocommit :- MySQLConnection. Autocommit value can be assigned as True or False to enable or disable the auto-commit feature of MySQL. By default, its value is False.

Post a Comment

You can help us by Clicking on ads. ^_^
Please do not send spam comment : )

Previous Post Next Post