START TRANSACTION
START TRANSACTION*
| Does not require any parameters |
|---|
Description
TART TRANSACTION starts a transaction in the current process. All changes to the data (records) of the database within the transaction are stored temporarily until the transaction is accepted (validated) or canceled.
You can nest several transactions (sub-transactions). Each transaction or sub-transaction must eventually be cancelled or validated. Note that if the main transaction is cancelled, all the sub-transactions are cancelled as well, regardless of their result.
See also
CANCEL TRANSACTION
In transaction
Transaction level
Transactions
VALIDATE TRANSACTION
Properties
| Command number | 239 |
| Thread safe | ✓ |