|
1887.3.2
by Brian Aker
Extended documentation. |
1 |
START TRANSACTION
|
2 |
======================
|
|
3 |
||
|
2194.5.2
by Andrew Hutchings
Fix SQL markup |
4 |
A transaction can be started with either the BEGIN or START TRANSACTION statements. It can also be started by any statement when AUTOCOMMIT is disabled. A transaction can then run until either the connection to the database is dropped (in which case it is rolled back), or an explicit rollback or a commit command is sent. |
5 |
||
6 |
.. code-block:: mysql |
|
|
1887.3.2
by Brian Aker
Extended documentation. |
7 |
|
|
1994.4.2
by Marisa Plumb
modified transaction docs |
8 |
START TRANSACTION [WITH CONSISTENT SNAPSHOT] |
|
1994.5.10
by Stewart Smith
add BEGIN to start_transaction docs. also about near future of having error on BEGIn; BEGIN; |
9 |
BEGIN
|
10 |
||
|
2165.2.1
by Andrew Hutchings
Initial cleanups |
11 |
.. warning:: |
12 |
||
|
1994.4.82
by Marisa Plumb
additions and updates to transaction docs |
13 |
If you are currently already in a transaction, Drizzle will give a warning |
|
2165.2.1
by Andrew Hutchings
Initial cleanups |
14 |
stating that you are in a transaction in a similar way to PostgreSQL. |
15 |
This is instead of implicitly committing the transaction in the way MySQL |
|
16 |
does. |