From: stefan
Date: December 19 2005 3:41pm
Subject: svn commit - mysqldoc@docsrva: r596 - in trunk: refman-4.1 refman-5.0 refman-5.1
List-Archive: http://lists.mysql.com/commits/255
Message-Id: <200512191541.jBJFf7Y5000444@docsrva.mysql.com>
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: 8bit

Author: shinz
Date: 2005-12-19 16:41:06 +0100 (Mon, 19 Dec 2005)
New Revision: 596

Log:
Add pointer from REPLACE section to INSERT ... ON DUPLICATE KEY UPDATE

Modified:
   trunk/refman-4.1/sql-syntax.xml
   trunk/refman-5.0/sql-syntax.xml
   trunk/refman-5.1/sql-syntax.xml

Modified: trunk/refman-4.1/sql-syntax.xml
===================================================================
--- trunk/refman-4.1/sql-syntax.xml	2005-12-19 14:40:47 UTC (rev 595)
+++ trunk/refman-4.1/sql-syntax.xml	2005-12-19 15:41:06 UTC (rev 596)
@@ -5820,6 +5820,18 @@
       </para>
 
       <para>
+        <literal>REPLACE</literal> is a MySQL extension to the SQL
+        standard. It either inserts, or <emphasis>deletes</emphasis> 
+        and inserts. If you're looking for a statement that follows 
+        the SQL standard, and that either inserts or 
+        <emphasis>updates</emphasis>, look for the
+        <literal>INSERT &hellip; ON DUPLICATE KEY UPDATE</literal>
+        statement; see <xref linkend="insert"/>.
+        <literal>INSERT &hellip; ON DUPLICATE KEY UPDATE</literal>
+        is available as of MySQL 4.1.0.
+      </para>
+      
+      <para>
         Note that unless the table has a <literal>PRIMARY KEY</literal>
         or <literal>UNIQUE</literal> index, using a
         <literal>REPLACE</literal> statement makes no sense. It becomes

Modified: trunk/refman-5.0/sql-syntax.xml
===================================================================
--- trunk/refman-5.0/sql-syntax.xml	2005-12-19 14:40:47 UTC (rev 595)
+++ trunk/refman-5.0/sql-syntax.xml	2005-12-19 15:41:06 UTC (rev 596)
@@ -5888,6 +5888,16 @@
       </para>
 
       <para>
+        <literal>REPLACE</literal> is a MySQL extension to the SQL
+        standard. It either inserts, or <emphasis>deletes</emphasis> 
+        and inserts. If you're looking for a statement that follows 
+        the SQL standard, and that either inserts or 
+        <emphasis>updates</emphasis>, look for the
+        <literal>INSERT &hellip; ON DUPLICATE KEY UPDATE</literal>
+        statement; see <xref linkend="insert"/>.
+      </para>
+      
+      <para>
         Note that unless the table has a <literal>PRIMARY KEY</literal>
         or <literal>UNIQUE</literal> index, using a
         <literal>REPLACE</literal> statement makes no sense. It becomes

Modified: trunk/refman-5.1/sql-syntax.xml
===================================================================
--- trunk/refman-5.1/sql-syntax.xml	2005-12-19 14:40:47 UTC (rev 595)
+++ trunk/refman-5.1/sql-syntax.xml	2005-12-19 15:41:06 UTC (rev 596)
@@ -6467,6 +6467,16 @@
         record is deleted before the new record is inserted. See
         <xref linkend="insert"/>.
       </para>
+      
+      <para>
+        <literal>REPLACE</literal> is a MySQL extension to the SQL
+        standard. It either inserts, or <emphasis>deletes</emphasis> 
+        and inserts. If you're looking for a statement that follows 
+        the SQL standard, and that either inserts or 
+        <emphasis>updates</emphasis>, look for the
+        <literal>INSERT &hellip; ON DUPLICATE KEY UPDATE</literal>
+        statement; see <xref linkend="insert"/>.
+      </para>
 
       <para>
         Note that unless the table has a <literal>PRIMARY KEY</literal>