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
instead of calling the BEGIN/COMMIT/END through run-query
Optional <database> is specified in "@"
clause and is the name of the database_config_file
run-query @mydb="insert into employee (name, dateOfHire) values ('%s', now())" : "Terry" no-loop