svn commit - mysqldoc@docsrva: r4935 - in trunk: . refman-4.1 refman-5.0 refman-5.1

[paul]

Author: paul
Date: 2007-02-14 16:20:01 +0100 (Wed, 14 Feb 2007)
New Revision: 4935

Log:
 r13737@kite-hub:  paul | 2007-01-23 12:57:33 -0600
 Minor addition to description for AUTO_INCREMENT table option.


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

Property changes on: trunk
___________________________________________________________________
Name: svk:merge
   - 4767c598-dc10-0410-bea0-d01b485662eb:/mysqldoc-local/mysqldoc/trunk:19804
7d8d2c4e-af1d-0410-ab9f-b038ce55645b:/mysqldoc-local/mysqldoc:16183
b5ec3a16-e900-0410-9ad2-d183a3acac99:/mysqldoc-local/mysqldoc/trunk:14218
bf112a9c-6c03-0410-a055-ad865cd57414:/mysqldoc-local/mysqldoc/trunk:13520
   + 4767c598-dc10-0410-bea0-d01b485662eb:/mysqldoc-local/mysqldoc/trunk:19804
7d8d2c4e-af1d-0410-ab9f-b038ce55645b:/mysqldoc-local/mysqldoc:16183
b5ec3a16-e900-0410-9ad2-d183a3acac99:/mysqldoc-local/mysqldoc/trunk:14218
bf112a9c-6c03-0410-a055-ad865cd57414:/mysqldoc-local/mysqldoc/trunk:13737


Modified: trunk/refman-4.1/sql-syntax.xml
===================================================================
--- trunk/refman-4.1/sql-syntax.xml	2007-02-14 15:11:48 UTC (rev 4934)
+++ trunk/refman-4.1/sql-syntax.xml	2007-02-14 15:20:01 UTC (rev 4935)
Changed blocks: 1, Lines Added: 3, Lines Deleted: 1; 749 bytes

@@ -2273,7 +2273,9 @@
             <literal>CREATE TABLE</literal> statements, you can also use
             <literal>ALTER TABLE <replaceable>tbl_name</replaceable>
             AUTO_INCREMENT = <replaceable>N</replaceable></literal> to
-            reset the <literal>AUTO_INCREMENT</literal> value.
+            reset the <literal>AUTO_INCREMENT</literal> value. The value
+            cannot be set lower than the maximum value currently in the
+            column.
           </para>
         </listitem>
 


Modified: trunk/refman-5.0/sql-syntax.xml
===================================================================
--- trunk/refman-5.0/sql-syntax.xml	2007-02-14 15:11:48 UTC (rev 4934)
+++ trunk/refman-5.0/sql-syntax.xml	2007-02-14 15:20:01 UTC (rev 4935)
Changed blocks: 1, Lines Added: 3, Lines Deleted: 1; 749 bytes

@@ -2316,7 +2316,9 @@
             <literal>CREATE TABLE</literal> statements, you can also use
             <literal>ALTER TABLE <replaceable>tbl_name</replaceable>
             AUTO_INCREMENT = <replaceable>N</replaceable></literal> to
-            reset the <literal>AUTO_INCREMENT</literal> value.
+            reset the <literal>AUTO_INCREMENT</literal> value. The value
+            cannot be set lower than the maximum value currently in the
+            column.
           </para>
         </listitem>
 


Modified: trunk/refman-5.1/sql-syntax.xml
===================================================================
--- trunk/refman-5.1/sql-syntax.xml	2007-02-14 15:11:48 UTC (rev 4934)
+++ trunk/refman-5.1/sql-syntax.xml	2007-02-14 15:20:01 UTC (rev 4935)
Changed blocks: 2, Lines Added: 10, Lines Deleted: 7; 1822 bytes

@@ -2989,12 +2989,13 @@
             The initial <literal>AUTO_INCREMENT</literal> value for the
             table. In MySQL &current-series;, this works for
             <literal>MyISAM</literal>, <literal>MEMORY</literal>, and
-            <literal>InnoDB</literal> tables. To set the first
-            auto-increment value for engines that do not support the
-            <literal>AUTO_INCREMENT</literal> table option, insert a
-            <quote>dummy</quote> row with a value one less than the
-            desired value after creating the table, and then delete the
-            dummy row.
+            <literal>InnoDB</literal> tables. It also works for
+            <literal>ARCHIVE</literal> tables as of MySQL 5.1.6. To set
+            the first auto-increment value for engines that do not
+            support the <literal>AUTO_INCREMENT</literal> table option,
+            insert a <quote>dummy</quote> row with a value one less than
+            the desired value after creating the table, and then delete
+            the dummy row.
           </para>
 
           <para>

@@ -3003,7 +3004,9 @@
             <literal>CREATE TABLE</literal> statements, you can also use
             <literal>ALTER TABLE <replaceable>tbl_name</replaceable>
             AUTO_INCREMENT = <replaceable>N</replaceable></literal> to
-            reset the <literal>AUTO_INCREMENT</literal> value.
+            reset the <literal>AUTO_INCREMENT</literal> value. The value
+            cannot be set lower than the maximum value currently in the
+            column.
           </para>
         </listitem>