Ignite supports the following statements that allow users to start, commit or rollback a transaction.
BEGIN [TRANSACTION] COMMIT [TRANSACTION] ROLLBACK [TRANSACTION]
BEGINstatement begins a new transaction.
COMMITcommits the current transaction.
ROLLBACKrolls back the current transaction.
DDL statements are not supported inside transactions.
ROLLBACK commands allow you to handle SQL Transactions. A transaction is a sequence of SQL operations that starts with the
BEGIN statement and ends with the
COMMIT statement. The operations in a transaction either all succeed or all fail.
ROLLBACK [TRANSACTION] statement undoes all updates made since the last time a
ROLLBACK command was used.
Add a person and update the city population by 1 in a single transaction.
BEGIN; INSERT INTO Person (id, name, city_id) VALUES (1, 'John Doe', 3); Update City SET population = population + 1 where id = 3; COMMIT;
Roll back the changes made by the previous commands.
BEGIN; INSERT INTO Person (id, name, city_id) VALUES (1, 'John Doe', 3); Update City SET population = population + 1 where id = 3; ROLLBACK;