List:Commits« Previous MessageNext Message »
From:jon.stephens Date:April 26 2010 9:33am
Subject:svn commit - mysqldoc@docsrva: r20224 - in trunk: refman-5.0 refman-5.1 refman-5.4 refman-5.5 refman-6.0
View as plain text  
Author: jstephens
Date: 2010-04-26 11:33:46 +0200 (Mon, 26 Apr 2010)
New Revision: 20224

Log:

Combined items concerning inserts/selects to/from same table to remove ambiguity (user comment)



Modified:
   trunk/refman-5.0/sql-syntax-data-manipulation.xml
   trunk/refman-5.1/sql-syntax-data-manipulation.xml
   trunk/refman-5.4/sql-syntax-data-manipulation.xml
   trunk/refman-5.5/sql-syntax-data-manipulation.xml
   trunk/refman-6.0/sql-syntax-data-manipulation.xml


Modified: trunk/refman-5.0/sql-syntax-data-manipulation.xml
===================================================================
--- trunk/refman-5.0/sql-syntax-data-manipulation.xml	2010-04-26 08:18:36 UTC (rev 20223)
+++ trunk/refman-5.0/sql-syntax-data-manipulation.xml	2010-04-26 09:33:46 UTC (rev 20224)
Changed blocks: 2, Lines Added: 12, Lines Deleted: 13; 2184 bytes

@@ -1557,12 +1557,18 @@
             <literal role="stmt">INSERT</literal> statement may appear
             in the <literal>FROM</literal> clause of the
             <literal role="stmt">SELECT</literal> part of the query.
-            (This was not possible in some older versions of MySQL.) In
-            this case, MySQL creates a temporary table to hold the rows
-            from the <literal role="stmt">SELECT</literal> and then
-            inserts those rows into the target table. However, it
-            remains true that you cannot use <literal>INSERT INTO t ...
-            SELECT ... FROM t</literal> when <literal>t</literal> is a
+            (This was not possible in some older versions of MySQL.)
+            However, you cannot insert into a table and select from the
+            same table in a subquery.
+          </para>
+
+          <para>
+            When selecting from and inserting into a table at the same
+            time, MySQL creates a temporary table to hold the rows from
+            the <literal role="stmt">SELECT</literal> and then inserts
+            those rows into the target table. However, it remains true
+            that you cannot use <literal>INSERT INTO t ... SELECT ...
+            FROM t</literal> when <literal>t</literal> is a
             <literal>TEMPORARY</literal> table, because
             <literal>TEMPORARY</literal> tables cannot be referred to
             twice in the same statement (see

@@ -1587,13 +1593,6 @@
 
         <listitem>
           <para>
-            Currently, you cannot insert into a table and select from
-            the same table in a subquery.
-          </para>
-        </listitem>
-
-        <listitem>
-          <para>
             To avoid ambiguous column reference problems when the
             <literal role="stmt">SELECT</literal> and the
             <literal role="stmt">INSERT</literal> refer to the same


Modified: trunk/refman-5.1/sql-syntax-data-manipulation.xml
===================================================================
--- trunk/refman-5.1/sql-syntax-data-manipulation.xml	2010-04-26 08:18:36 UTC (rev 20223)
+++ trunk/refman-5.1/sql-syntax-data-manipulation.xml	2010-04-26 09:33:46 UTC (rev 20224)
Changed blocks: 2, Lines Added: 12, Lines Deleted: 13; 2184 bytes

@@ -1625,12 +1625,18 @@
             <literal role="stmt">INSERT</literal> statement may appear
             in the <literal>FROM</literal> clause of the
             <literal role="stmt">SELECT</literal> part of the query.
-            (This was not possible in some older versions of MySQL.) In
-            this case, MySQL creates a temporary table to hold the rows
-            from the <literal role="stmt">SELECT</literal> and then
-            inserts those rows into the target table. However, it
-            remains true that you cannot use <literal>INSERT INTO t ...
-            SELECT ... FROM t</literal> when <literal>t</literal> is a
+            (This was not possible in some older versions of MySQL.)
+            However, you cannot insert into a table and select from the
+            same table in a subquery.
+          </para>
+
+          <para>
+            When selecting from and inserting into a table at the same
+            time, MySQL creates a temporary table to hold the rows from
+            the <literal role="stmt">SELECT</literal> and then inserts
+            those rows into the target table. However, it remains true
+            that you cannot use <literal>INSERT INTO t ... SELECT ...
+            FROM t</literal> when <literal>t</literal> is a
             <literal>TEMPORARY</literal> table, because
             <literal>TEMPORARY</literal> tables cannot be referred to
             twice in the same statement (see

@@ -1655,13 +1661,6 @@
 
         <listitem>
           <para>
-            Currently, you cannot insert into a table and select from
-            the same table in a subquery.
-          </para>
-        </listitem>
-
-        <listitem>
-          <para>
             To avoid ambiguous column reference problems when the
             <literal role="stmt">SELECT</literal> and the
             <literal role="stmt">INSERT</literal> refer to the same


Modified: trunk/refman-5.4/sql-syntax-data-manipulation.xml
===================================================================
--- trunk/refman-5.4/sql-syntax-data-manipulation.xml	2010-04-26 08:18:36 UTC (rev 20223)
+++ trunk/refman-5.4/sql-syntax-data-manipulation.xml	2010-04-26 09:33:46 UTC (rev 20224)
Changed blocks: 2, Lines Added: 12, Lines Deleted: 13; 2184 bytes

@@ -1619,12 +1619,18 @@
             <literal role="stmt">INSERT</literal> statement may appear
             in the <literal>FROM</literal> clause of the
             <literal role="stmt">SELECT</literal> part of the query.
-            (This was not possible in some older versions of MySQL.) In
-            this case, MySQL creates a temporary table to hold the rows
-            from the <literal role="stmt">SELECT</literal> and then
-            inserts those rows into the target table. However, it
-            remains true that you cannot use <literal>INSERT INTO t ...
-            SELECT ... FROM t</literal> when <literal>t</literal> is a
+            (This was not possible in some older versions of MySQL.)
+            However, you cannot insert into a table and select from the
+            same table in a subquery.
+          </para>
+
+          <para>
+            When selecting from and inserting into a table at the same
+            time, MySQL creates a temporary table to hold the rows from
+            the <literal role="stmt">SELECT</literal> and then inserts
+            those rows into the target table. However, it remains true
+            that you cannot use <literal>INSERT INTO t ... SELECT ...
+            FROM t</literal> when <literal>t</literal> is a
             <literal>TEMPORARY</literal> table, because
             <literal>TEMPORARY</literal> tables cannot be referred to
             twice in the same statement (see

@@ -1649,13 +1655,6 @@
 
         <listitem>
           <para>
-            Currently, you cannot insert into a table and select from
-            the same table in a subquery.
-          </para>
-        </listitem>
-
-        <listitem>
-          <para>
             To avoid ambiguous column reference problems when the
             <literal role="stmt">SELECT</literal> and the
             <literal role="stmt">INSERT</literal> refer to the same


Modified: trunk/refman-5.5/sql-syntax-data-manipulation.xml
===================================================================
--- trunk/refman-5.5/sql-syntax-data-manipulation.xml	2010-04-26 08:18:36 UTC (rev 20223)
+++ trunk/refman-5.5/sql-syntax-data-manipulation.xml	2010-04-26 09:33:46 UTC (rev 20224)
Changed blocks: 2, Lines Added: 12, Lines Deleted: 13; 2184 bytes

@@ -1669,12 +1669,18 @@
             <literal role="stmt">INSERT</literal> statement may appear
             in the <literal>FROM</literal> clause of the
             <literal role="stmt">SELECT</literal> part of the query.
-            (This was not possible in some older versions of MySQL.) In
-            this case, MySQL creates a temporary table to hold the rows
-            from the <literal role="stmt">SELECT</literal> and then
-            inserts those rows into the target table. However, it
-            remains true that you cannot use <literal>INSERT INTO t ...
-            SELECT ... FROM t</literal> when <literal>t</literal> is a
+            (This was not possible in some older versions of MySQL.)
+            However, you cannot insert into a table and select from the
+            same table in a subquery.
+          </para>
+
+          <para>
+            When selecting from and inserting into a table at the same
+            time, MySQL creates a temporary table to hold the rows from
+            the <literal role="stmt">SELECT</literal> and then inserts
+            those rows into the target table. However, it remains true
+            that you cannot use <literal>INSERT INTO t ... SELECT ...
+            FROM t</literal> when <literal>t</literal> is a
             <literal>TEMPORARY</literal> table, because
             <literal>TEMPORARY</literal> tables cannot be referred to
             twice in the same statement (see

@@ -1699,13 +1705,6 @@
 
         <listitem>
           <para>
-            Currently, you cannot insert into a table and select from
-            the same table in a subquery.
-          </para>
-        </listitem>
-
-        <listitem>
-          <para>
             To avoid ambiguous column reference problems when the
             <literal role="stmt">SELECT</literal> and the
             <literal role="stmt">INSERT</literal> refer to the same


Modified: trunk/refman-6.0/sql-syntax-data-manipulation.xml
===================================================================
--- trunk/refman-6.0/sql-syntax-data-manipulation.xml	2010-04-26 08:18:36 UTC (rev 20223)
+++ trunk/refman-6.0/sql-syntax-data-manipulation.xml	2010-04-26 09:33:46 UTC (rev 20224)
Changed blocks: 2, Lines Added: 9, Lines Deleted: 9; 1836 bytes

@@ -1663,12 +1663,17 @@
             <literal role="stmt">INSERT</literal> statement may appear
             in the <literal>FROM</literal> clause of the
             <literal role="stmt">SELECT</literal> part of the query.
-            (This was not possible in some older versions of MySQL.) In
-            this case, MySQL creates a temporary table to hold the rows
+            (This was not possible in some older versions of MySQL.) However,
+            you cannot insert into a table and select from the same table in a
+            subquery. 
+          </para>
+          <para>
+            When selecting from and inserting into a table at the same
+            time, MySQL creates a temporary table to hold the rows 
             from the <literal role="stmt">SELECT</literal> and then
             inserts those rows into the target table. However, it
             remains true that you cannot use <literal>INSERT INTO t ...
-            SELECT ... FROM t</literal> when <literal>t</literal> is a
+              SELECT ... FROM t</literal> when <literal>t</literal> is a
             <literal>TEMPORARY</literal> table, because
             <literal>TEMPORARY</literal> tables cannot be referred to
             twice in the same statement (see

@@ -1691,12 +1696,7 @@
           </para>
         </listitem>
 
-        <listitem>
-          <para>
-            Currently, you cannot insert into a table and select from
-            the same table in a subquery.
-          </para>
-        </listitem>
+        
 
         <listitem>
           <para>


Thread
svn commit - mysqldoc@docsrva: r20224 - in trunk: refman-5.0 refman-5.1 refman-5.4 refman-5.5 refman-6.0jon.stephens26 Apr