From 87aafa160003eb000de54bd1b184eb3b017592ea Mon Sep 17 00:00:00 2001 From: Neil Conway Date: Tue, 1 Mar 2005 23:45:00 +0000 Subject: [PATCH] SGML improvements to the DML chapter. --- doc/src/sgml/dml.sgml | 24 ++++++++++++++---------- 1 file changed, 14 insertions(+), 10 deletions(-) diff --git a/doc/src/sgml/dml.sgml b/doc/src/sgml/dml.sgml index 91e7e137f1..b70990bb86 100644 --- a/doc/src/sgml/dml.sgml +++ b/doc/src/sgml/dml.sgml @@ -1,4 +1,4 @@ - + Data Manipulation @@ -38,10 +38,10 @@ - To create a new row, use the INSERT command. - The command requires the table name and a value for each of the - columns of the table. For example, consider the products table - from : + To create a new row, use the command. The command requires the + table name and a value for each of the columns of the table. For + example, consider the products table from : CREATE TABLE products ( product_no integer, @@ -98,7 +98,9 @@ INSERT INTO products DEFAULT VALUES; To do bulk loads, that is, inserting a lot of data, take a look at the command. It is not as flexible as the - INSERT command, but is more efficient. + INSERT command, but is more efficient. Refer to + for more information on improving bulk + loading performance. @@ -188,7 +190,7 @@ UPDATE products SET price = price * 1.10; You can update more than one column in an - UPDATE command by listing more than one + UPDATE command by listing more than one assignment in the SET clause. For example: UPDATE mytable SET a = 5, b = 3, c = 1 WHERE a > 0; @@ -222,9 +224,11 @@ UPDATE mytable SET a = 5, b = 3, c = 1 WHERE a > 0; - You use the DELETE command to remove rows; the - syntax is very similar to the UPDATE command. - For instance, to remove all rows from the products table that have a price of 10, use + You use the command to remove rows; the syntax is + very similar to the UPDATE command. For + instance, to remove all rows from the products table that have a + price of 10, use DELETE FROM products WHERE price = 10; -- 2.40.0