Author: shinz
Date: 2005-10-28 14:29:19 +0200 (Fri, 28 Oct 2005)
New Revision: 194
Log:
Commit changes that didn't make it yesterday
Modified:
trunk/refman-4.1/tutorial.xml
trunk/refman-5.0/tutorial.xml
trunk/refman-5.1/tutorial.xml
Modified: trunk/refman-4.1/tutorial.xml
===================================================================
--- trunk/refman-4.1/tutorial.xml 2005-10-28 10:52:47 UTC (rev 193)
+++ trunk/refman-4.1/tutorial.xml 2005-10-28 12:29:19 UTC (rev 194)
@@ -3894,7 +3894,48 @@
Note that this feature is available for
<literal>InnoDB</literal> tables only as of MySQL 4.1.12.
</para>
+
+ <para>
+ More information about <literal>AUTO_INCREMENT</literal> is
+ available here:
+ <itemizedlist>
+ <listitem>
+ <para>
+ How to assign the <literal>AUTO_INCREMENT</literal> attribute
+ to a column:
+ <xref linkend="create-table"/> and <xref
linkend="alter-table"/>.
+ </para>
+ </listitem>
+ <listitem>
+ <para>
+ How <literal>AUTO_INCREMENT</literal> behaves depending on the
+ SQL mode:
+ <xref linkend="server-sql-mode"/>.
+ </para>
+ </listitem>
+ <listitem>
+ <para>
+ Find the row that contains the most recent AUTO_INCREMENT value:
+ <xref linkend="comparison-operators"/>.
+ </para>
+ </listitem>
+ <listitem>
+ <para>
+ Set the <literal>AUTO_INCREMENT</literal> value to be used:
+ <xref linkend="set-option"/>.
+ </para>
+ </listitem>
+ <listitem>
+ <para>
+ <literal>AUTO_INCREMENT</literal> and replication:
+ <xref linkend="replication-features"/>.
+ </para>
+ </listitem>
+ </itemizedlist>
+
+ </para>
+
</section>
</section>
Modified: trunk/refman-5.0/tutorial.xml
===================================================================
--- trunk/refman-5.0/tutorial.xml 2005-10-28 10:52:47 UTC (rev 193)
+++ trunk/refman-5.0/tutorial.xml 2005-10-28 12:29:19 UTC (rev 194)
@@ -3737,6 +3737,56 @@
mysql> <userinput>ALTER TABLE tbl AUTO_INCREMENT = 100;</userinput>
</programlisting>
+ <para>
+ More information about <literal>AUTO_INCREMENT</literal> is
+ available here:
+
+ <itemizedlist>
+ <listitem>
+ <para>
+ How to assign the <literal>AUTO_INCREMENT</literal> attribute
+ to a column:
+ <xref linkend="create-table"/> and <xref
linkend="alter-table"/>.
+ </para>
+ </listitem>
+ <listitem>
+ <para>
+ How <literal>AUTO_INCREMENT</literal> behaves depending on the
+ SQL mode:
+ <xref linkend="server-sql-mode"/>.
+ </para>
+ </listitem>
+ <listitem>
+ <para>
+ Find the row that contains the most recent AUTO_INCREMENT value:
+ <xref linkend="comparison-operators"/>.
+ </para>
+ </listitem>
+ <listitem>
+ <para>
+ Set the <literal>AUTO_INCREMENT</literal> value to be used:
+ <xref linkend="set-option"/>.
+ </para>
+ </listitem>
+ <listitem>
+ <para>
+ <literal>AUTO_INCREMENT</literal> and replication:
+ <xref linkend="replication-features"/>.
+ </para>
+ </listitem>
+ <listitem>
+ <para>
+ Server-system variables related to
<literal>AUTO_INCREMENT</literal>
+ (<literal>auto_increment_increment</literal> and
+ <literal>auto_increment_offset</literal>)
+ that can be used for replication:
+ <xref linkend="server-system-variables"/>.
+ </para>
+ </listitem>
+ </itemizedlist>
+
+ </para>
+
</section>
</section>
Modified: trunk/refman-5.1/tutorial.xml
===================================================================
--- trunk/refman-5.1/tutorial.xml 2005-10-28 10:52:47 UTC (rev 193)
+++ trunk/refman-5.1/tutorial.xml 2005-10-28 12:29:19 UTC (rev 194)
@@ -3726,6 +3726,56 @@
mysql> <userinput>ALTER TABLE tbl AUTO_INCREMENT = 100;</userinput>
</programlisting>
+ <para>
+ More information about <literal>AUTO_INCREMENT</literal> is
+ available here:
+
+ <itemizedlist>
+ <listitem>
+ <para>
+ How to assign the <literal>AUTO_INCREMENT</literal> attribute
+ to a column:
+ <xref linkend="create-table"/> and <xref
linkend="alter-table"/>.
+ </para>
+ </listitem>
+ <listitem>
+ <para>
+ How <literal>AUTO_INCREMENT</literal> behaves depending on the
+ SQL mode:
+ <xref linkend="server-sql-mode"/>.
+ </para>
+ </listitem>
+ <listitem>
+ <para>
+ Find the row that contains the most recent AUTO_INCREMENT value:
+ <xref linkend="comparison-operators"/>.
+ </para>
+ </listitem>
+ <listitem>
+ <para>
+ Set the <literal>AUTO_INCREMENT</literal> value to be used:
+ <xref linkend="set-option"/>.
+ </para>
+ </listitem>
+ <listitem>
+ <para>
+ <literal>AUTO_INCREMENT</literal> and replication:
+ <xref linkend="replication-features"/>.
+ </para>
+ </listitem>
+ <listitem>
+ <para>
+ Server-system variables related to
<literal>AUTO_INCREMENT</literal>
+ (<literal>auto_increment_increment</literal> and
+ <literal>auto_increment_offset</literal>)
+ that can be used for replication:
+ <xref linkend="server-system-variables"/>.
+ </para>
+ </listitem>
+ </itemizedlist>
+
+ </para>
+
</section>
</section>
| Thread |
|---|
| • svn commit - mysqldoc@docsrva: r194 - in trunk: refman-4.1 refman-5.0 refman-5.1 | shinz | 28 Oct |