If the SQL transaction boundary statements START TRANSACTION and COMMIT are not used,by default all of the SQL statements that comprise the entire logical transaction are considered a single transaction.

Question

Quizplus · Accepted Answer

By default, each individual SQL statement is considered a transaction if explicit transaction boundaries (START TRANSACTION and COMMIT) are not used. This is known as autocommit mode, where each statement is automatically committed upon completion.

If the SQL Transaction Boundary Statements START TRANSACTION and COMMIT