Begins database transaction.
This statement begins a database transaction. <options> is any additional options to database's BEGIN/START you wish to supply and must immediately follow begin-transaction.
Once you start a transaction with begin-transaction, you must either commit it with
commit-transaction or rollback with
rollback-transaction. If you do neither, your transaction will be rolled back once the request has completed and your program will stop with an error message. This is because opening a transaction and leaving without committing or a rollback is a bug in your program.
You must use begin-transaction,
commit-transaction and
rollback-transaction instead of calling the BEGIN/COMMIT/END through
run-query.
Database
Optional <database> is specified in
"@" clause and is the name of the
database_config_file.
begin-transaction @mydb
run-query @mydb="insert into employee (name, dateOfHire) values ('%s', now())" : "Terry" no-loop
commit-transaction @mydb