BEGIN, COMMIT, ROLLBACK

A transaction can only be used on insert, nor update or delete. You can check the state of this transaction by

1. Begin a transaction without a label, then commit it

1. Begin a transaction without a label, then abort it

All the data in the sql between and rollback will be aborted, nothing will be inserted into the table.

BEGIN, COMMIT, ROLLBACK