diff options
Diffstat (limited to 'doc/src/sgml/dml.sgml')
| -rw-r--r-- | doc/src/sgml/dml.sgml | 26 |
1 files changed, 25 insertions, 1 deletions
diff --git a/doc/src/sgml/dml.sgml b/doc/src/sgml/dml.sgml index 6476fcf14a..fb9cbf9749 100644 --- a/doc/src/sgml/dml.sgml +++ b/doc/src/sgml/dml.sgml @@ -1,4 +1,4 @@ -<!-- $Header: /cvsroot/pgsql/doc/src/sgml/dml.sgml,v 1.5 2003/08/10 01:20:34 tgl Exp $ --> +<!-- $Header: /cvsroot/pgsql/doc/src/sgml/dml.sgml,v 1.6 2003/08/31 17:32:18 petere Exp $ --> <chapter id="dml"> <title>Data Manipulation</title> @@ -20,6 +20,14 @@ <sect1 id="dml-insert"> <title>Inserting Data</title> + <indexterm zone="dml-insert"> + <primary>inserting</primary> + </indexterm> + + <indexterm zone="dml-insert"> + <primary>INSERT</primary> + </indexterm> + <para> When a table is created, it contains no data. The first thing to do before a database can be of much use is to insert data. Data is @@ -98,6 +106,14 @@ INSERT INTO products DEFAULT VALUES; <sect1 id="dml-update"> <title>Updating Data</title> + <indexterm zone="dml-update"> + <primary>updating</primary> + </indexterm> + + <indexterm zone="dml-update"> + <primary>UPDATE</primary> + </indexterm> + <para> The modification of data that is already in the database is referred to as updating. You can update individual rows, all the @@ -182,6 +198,14 @@ UPDATE mytable SET a = 5, b = 3, c = 1 WHERE a > 0; <sect1 id="dml-delete"> <title>Deleting Data</title> + <indexterm zone="dml-delete"> + <primary>deleting</primary> + </indexterm> + + <indexterm zone="dml-delete"> + <primary>DELETE</primary> + </indexterm> + <para> So far we have explained how to add data to tables and how to change data. What remains is to discuss how to remove data that is |