add start_transaction(), commit() and rollback() methods
Note: this supports nested transactions. For example:
start_transaction(); UPDATE 1 start_transaction(); UPDATE 2 start_transaction(); UPDATE 3 commit(); rollback(); commit();
Will result in:
START TRANSACTION
UPDATE 1
UPDATE 2
UPDATE 3
ROLLBACK
Since at least one ROLLBACK was fired.