The transaction commit statement ends a transaction. The table changes made within the transaction are “committed,” making them permanent.
transaction commit
None
Table operations can be undone by using the transaction rollback statement instead of a transaction commit. Transaction processing capability isn’t available with all database types and its availability can be checked using the havetransactions() function.