~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to docs/insert.rst

  • Committer: Andrew Hutchings
  • Date: 2011-02-23 14:17:23 UTC
  • mto: (2196.1.3 build)
  • mto: This revision was merged to the branch mainline in revision 2197.
  • Revision ID: andrew@linuxjedi.co.uk-20110223141723-spck4t85k8igzk4j
Markup fixes

Show diffs side-by-side

added added

removed removed

Lines of Context:
5
5
 
6
6
A type query:
7
7
 
8
 
INSERT INTO A VALUES ("1");
 
8
.. code-block:: mysql
9
9
 
 
10
   INSERT INTO A VALUES ("1");
10
11
 
11
12
.. todo::
12
13
 
34
35
 
35
36
VALUE is a synonym for VALUES where performing a single or multirow INSERT.
36
37
 
37
 
**Performance**:
 
38
Performance
 
39
-----------
38
40
 
39
41
A multi-row INSERT involving three rows will require roughly one third of the time required to execute the three single-row statements. This performance improvement can become quite significant over a large number of statements.