~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to docs/commit.rst

  • Committer: Andrew Hutchings
  • Date: 2011-02-23 13:08:09 UTC
  • mto: (2196.1.3 build)
  • mto: This revision was merged to the branch mainline in revision 2197.
  • Revision ID: andrew@linuxjedi.co.uk-20110223130809-mbd2rypxod2tfre6
Fix SQL markup

Show diffs side-by-side

added added

removed removed

Lines of Context:
9
9
 
10
10
For example, DML statements do not implicitly commit the current transaction. If a user's DML statements have been used to update some data objects, and the updates need to be permanently recorded in the database, you can use the COMMIT command.
11
11
 
12
 
An example: ::
 
12
An example:
 
13
 
 
14
.. code-block:: mysql
13
15
 
14
16
        START TRANSACTION;
15
17
 
29
31
| 10  | twitter.com   | NULL  | 2011-02-03 08:39:16 |
30
32
+-----+---------------+-------+---------------------+
31
33
 
32
 
Then to save the information just inserted, simply issue the COMMIT command: ::
 
34
Then to save the information just inserted, simply issue the COMMIT command:
 
35
 
 
36
.. code-block:: mysql
33
37
 
34
38
        COMMIT;