Author: paul
Date: 2008-09-05 23:08:57 +0200 (Fri, 05 Sep 2008)
New Revision: 11684
Log:
r33661@frost: paul | 2008-09-05 13:33:05 -0500
LAST_INSERT_ID() clarification when INSERT ... ON DUPLICATE KEY UPDATE updates
rather than inserts a row
(Related to Bug#19243)
Modified:
trunk/refman-4.1/functions-core.xml
Property changes on: trunk
___________________________________________________________________
Name: svk:merge
- 4767c598-dc10-0410-bea0-d01b485662eb:/mysqldoc-local/mysqldoc/trunk:35828
7d8d2c4e-af1d-0410-ab9f-b038ce55645b:/mysqldoc-local/mysqldoc:33660
b5ec3a16-e900-0410-9ad2-d183a3acac99:/mysqldoc-local/mysqldoc/trunk:14218
bf112a9c-6c03-0410-a055-ad865cd57414:/mysqldoc-local/mysqldoc/trunk:32972
+ 4767c598-dc10-0410-bea0-d01b485662eb:/mysqldoc-local/mysqldoc/trunk:35828
7d8d2c4e-af1d-0410-ab9f-b038ce55645b:/mysqldoc-local/mysqldoc:33661
b5ec3a16-e900-0410-9ad2-d183a3acac99:/mysqldoc-local/mysqldoc/trunk:14218
bf112a9c-6c03-0410-a055-ad865cd57414:/mysqldoc-local/mysqldoc/trunk:32972
Modified: trunk/refman-4.1/functions-core.xml
===================================================================
--- trunk/refman-4.1/functions-core.xml 2008-09-05 21:08:51 UTC (rev 11683)
+++ trunk/refman-4.1/functions-core.xml 2008-09-05 21:08:57 UTC (rev 11684)
Changed blocks: 1, Lines Added: 9, Lines Deleted: 0; 949 bytes
@@ -14936,6 +14936,15 @@
</programlisting>
<para>
+ if a table contains an <literal>AUTO_INCREMENT</literal>
+ column and <literal>INSERT ... ON DUPLICATE KEY
+ UPDATE</literal> updates (rather than inserts) a row, the
+ value of <function role="sql">LAST_INSERT_ID()</function> is
+ not meaningful. For a workaround, see
+ <xref linkend="insert-on-duplicate"/>.
+ </para>
+
+ <para>
The currently executing statement does not affect the value
of <function role="sql">LAST_INSERT_ID()</function>. Suppose
that you generate an <literal>AUTO_INCREMENT</literal> value
| Thread |
|---|
| • svn commit - mysqldoc@docsrva: r11684 - in trunk: . refman-4.1 | paul.dubois | 5 Sep |
