Transaction Command Syntax:

1. BEGIN / START TRANSACTION:

PostgreSQL:

BEGIN;

BEGIN TRANSACTION;

BEGIN WORK;

MySQL:

START TRANSACTION;

BEGIN;

SQL Server:

BEGIN TRANSACTION;

BEGIN TRAN;

Oracle:

-- No explicit BEGIN (transactions start automatically)

-- Use SAVEPOINT to mark transaction start

2. COMMIT:

All databases:

COMMIT;

COMMIT TRANSACTION;

COMMIT WORK;

3. ROLLBACK:

All databases:

ROLLBACK;

ROLLBACK TRANSACTION;

ROLLBACK WORK;

4. SAVEPOINT:

PostgreSQL:

SAVEPOINT savepoint_name;

ROLLBACK TO SAVEPOINT savepoint_name;

RELEASE SAVEPOINT savepoint_name;

MySQL:

SAVEPOINT savepoint_name;

ROLLBACK TO SAVEPOINT savepoint_name;

RELEASE SAVEPOINT savepoint_name;

SQL Server:

SAVE TRANSACTION savepoint_name;

ROLLBACK TRANSACTION savepoint_name;

Oracle:

SAVEPOINT savepoint_name;

ROLLBACK TO SAVEPOINT savepoint_name;