← Back to branch summary

~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to docs/savepoints.rst

  • Committer: Stewart Smith
  • Date: 2011-01-14 05:11:45 UTC
  • mto: (2086.1.3 build)
  • mto: This revision was merged to the branch mainline in revision 2087.
  • Revision ID: stewart@flamingspork.com-20110114051145-xiputq4lvmtct377
storage engine docs. add bit about some temp table only engines.

Show diffs side-by-side

added added

removed removed

Lines of Context:
docs/savepoints.rst
5
5
 
6
6
        SAVEPOINT identifier
7
7
 
8
 
This sets a savepoint that can be returned to in the current transaction. The "identifier" is the name given to the new savepoint. If the identifier has already been used then the original identifier is replaced. Example:
9
 
 
10
 
.. code-block:: mysql
11
 
 
12
 
     SAVEPOINT A;
13
 
     INSERT INTO t1 values (1);
14
 
     SAVEPOINT A;
15
 
     INSERT INTO t1 values (2);
16
 
     ROLLBACK TO SAVEPOINT A;
17
 
 
18
 
Will only roll back the second insert statement.
 
8
This sets a savepoint that can be returned to in the current transaction. The "identifier" is the name given to the new savepoint. If the identifier has already been used then the original identifier is replaced.