Accuracer: The First And Only BDE Alternative
Client-Server Single-File Embedded Database for Delphi / C++Builder / Kylix
Introduction
The START TRANSACTION statement is used to start transaction in the database.
For more information read Transactions topic in Developer's Guide.
Syntax
START TRANSACTION
Here is an example:
START TRANSACTION;
INSERT INTO Table1 (NAME) VALUES('aaa');
UPDATE Table2 SET Field1 = Field1 + 1;
INSERT INTO Table1 (NAME) VALUES('bb');
COMMIT;
|