Author: jstephens
Date: 2007-09-03 11:18:51 +0200 (Mon, 03 Sep 2007)
New Revision: 7635
Log:
A Farewell To "ansi-diff-subqueries"
(in 5.0/5.1/5.2)
Modified:
trunk/refman-5.0/introduction.xml
trunk/refman-5.0/renamed-nodes.txt
trunk/refman-5.0/sql-syntax.xml
trunk/refman-5.1/introduction.xml
trunk/refman-5.1/renamed-nodes.txt
trunk/refman-5.1/sql-syntax.xml
trunk/refman-5.2/introduction.xml
trunk/refman-5.2/renamed-nodes.txt
trunk/refman-5.2/sql-syntax.xml
Modified: trunk/refman-5.0/introduction.xml
===================================================================
--- trunk/refman-5.0/introduction.xml 2007-09-03 08:52:12 UTC (rev 7634)
+++ trunk/refman-5.0/introduction.xml 2007-09-03 09:18:51 UTC (rev 7635)
Changed blocks: 1, Lines Added: 1, Lines Deleted: 21; 1178 bytes
@@ -1613,28 +1613,8 @@
</itemizedlist>
- <section id="ansi-diff-subqueries">
+
- <title>Subquery Support</title>
-
- <para>
- MySQL 4.1 and up supports subqueries and derived tables. A
- <quote>subquery</quote> is a <literal>SELECT</literal>
- statement nested within another statement. A <quote>derived
- table</quote> (an unnamed view) is a subquery in the
- <literal>FROM</literal> clause of another statement. See
- <xref linkend="subqueries"/>.
- </para>
-
- <para>
- For MySQL versions older than 4.1, most subqueries can be
- rewritten using joins or other methods. See
- <xref linkend="rewriting-subqueries"/>, for examples that show
- how to do this.
- </para>
-
- </section>
-
<section id="ansi-diff-select-into-table">
<title><literal>SELECT INTO TABLE</literal></title>
Modified: trunk/refman-5.0/renamed-nodes.txt
===================================================================
--- trunk/refman-5.0/renamed-nodes.txt 2007-09-03 08:52:12 UTC (rev 7634)
+++ trunk/refman-5.0/renamed-nodes.txt 2007-09-03 09:18:51 UTC (rev 7635)
Changed blocks: 1, Lines Added: 1, Lines Deleted: 0; 569 bytes
@@ -28,6 +28,7 @@
access97-export myodbc-usagenotes-apptips-microsoft-access
ado myodbc-usagenotes-apptips-microsoft-ado
ado--rs-addnew myodbc-examples-programming-vb-ado
+ansi-diff-subqueries subqueries
answering-questions mailing-list-use
asking-questions bug-reports
asp myodbc-usagenotes-apptips-microsoft-asp
Modified: trunk/refman-5.0/sql-syntax.xml
===================================================================
--- trunk/refman-5.0/sql-syntax.xml 2007-09-03 08:52:12 UTC (rev 7634)
+++ trunk/refman-5.0/sql-syntax.xml 2007-09-03 09:18:51 UTC (rev 7635)
Changed blocks: 4, Lines Added: 10, Lines Deleted: 19; 2437 bytes
@@ -10366,14 +10366,11 @@
</indexterm>
<para>
- In previous versions of MySQL (prior to MySQL 4.1), only
- nested queries of the form <literal>INSERT ... SELECT
- ...</literal> and <literal>REPLACE ... SELECT ...</literal>
- were supported. Although this is not the case in MySQL
- ¤t-series;, it is still true that there are sometimes
- other ways to test membership in a set of values. It is also
- true that on some occasions, it is not only possible to
- rewrite a query without a subquery, but it can be more
+ Although MySQL ¤t-series; supports subqueries (see
+ <xref linkend="subqueries"/>), it is still true that there are
+ sometimes other ways to test membership in a set of values. It
+ is also true that on some occasions, it is not only possible
+ to rewrite a query without a subquery, but it can be more
efficient to make use of some of these techniques rather than
to use subqueries. One of these is the <literal>IN()</literal>
construct:
@@ -10432,11 +10429,6 @@
Rewrite or drop the following paragraphs...
</remark>
- <remark role="note">
- Extra space inserted into "- -skip-column-names" to avoid XML
- parse error.
- </remark>
-
<!--
<para>
For more complicated subqueries, you can often create temporary
@@ -10474,10 +10466,9 @@
</para>
<programlisting>
- SELECT
- CONCAT('DELETE FROM tab1 WHERE pkid = ', "'", tab1.pkid, "'", ';')
- FROM tab1, tab2
- WHERE tab1.col1 = tab2.col2;
+SELECT CONCAT('DELETE FROM tab1 WHERE pkid = ', "'", tab1.pkid, "'", ';')
+ FROM tab1, tab2
+ WHERE tab1.col1 = tab2.col2;
</programlisting>
<para>
@@ -10487,8 +10478,8 @@
<command>mysql</command>:
</para>
- <programlisting>
- shell> mysql - -skip-column-names mydb < myscript.sql | mysql mydb
+<programlisting>
+shell> mysql &ddash;skip-column-names mydb < myscript.sql | mysql mydb
</programlisting>
</itemizedlist>
Modified: trunk/refman-5.1/introduction.xml
===================================================================
--- trunk/refman-5.1/introduction.xml 2007-09-03 08:52:12 UTC (rev 7634)
+++ trunk/refman-5.1/introduction.xml 2007-09-03 09:18:51 UTC (rev 7635)
Changed blocks: 1, Lines Added: 1, Lines Deleted: 21; 1178 bytes
@@ -1625,28 +1625,8 @@
</itemizedlist>
- <section id="ansi-diff-subqueries">
+
- <title>Subquery Support</title>
-
- <para>
- MySQL 4.1 and up supports subqueries and derived tables. A
- <quote>subquery</quote> is a <literal>SELECT</literal>
- statement nested within another statement. A <quote>derived
- table</quote> (an unnamed view) is a subquery in the
- <literal>FROM</literal> clause of another statement. See
- <xref linkend="subqueries"/>.
- </para>
-
- <para>
- For MySQL versions older than 4.1, most subqueries can be
- rewritten using joins or other methods. See
- <xref linkend="rewriting-subqueries"/>, for examples that show
- how to do this.
- </para>
-
- </section>
-
<section id="ansi-diff-select-into-table">
<title><literal>SELECT INTO TABLE</literal></title>
Modified: trunk/refman-5.1/renamed-nodes.txt
===================================================================
--- trunk/refman-5.1/renamed-nodes.txt 2007-09-03 08:52:12 UTC (rev 7634)
+++ trunk/refman-5.1/renamed-nodes.txt 2007-09-03 09:18:51 UTC (rev 7635)
Changed blocks: 1, Lines Added: 1, Lines Deleted: 0; 569 bytes
@@ -27,6 +27,7 @@
access97-export myodbc-usagenotes-apptips-microsoft-access
ado myodbc-usagenotes-apptips-microsoft-ado
ado--rs-addnew myodbc-examples-programming-vb-ado
+ansi-diff-subqueries subqueries
answering-questions mailing-list-use
asking-questions bug-reports
asp myodbc-usagenotes-apptips-microsoft-asp
Modified: trunk/refman-5.1/sql-syntax.xml
===================================================================
--- trunk/refman-5.1/sql-syntax.xml 2007-09-03 08:52:12 UTC (rev 7634)
+++ trunk/refman-5.1/sql-syntax.xml 2007-09-03 09:18:51 UTC (rev 7635)
Changed blocks: 4, Lines Added: 11, Lines Deleted: 20; 2523 bytes
@@ -12380,14 +12380,11 @@
</indexterm>
<para>
- In previous versions of MySQL (prior to MySQL 4.1), only
- nested queries of the form <literal>INSERT ... SELECT
- ...</literal> and <literal>REPLACE ... SELECT ...</literal>
- were supported. Although this is not the case in MySQL
- ¤t-series;, it is still true that there are sometimes
- other ways to test membership in a set of values. It is also
- true that on some occasions, it is not only possible to
- rewrite a query without a subquery, but it can be more
+ Although MySQL ¤t-series; supports subqueries (see
+ <xref linkend="subqueries"/>), it is still true that there are
+ sometimes other ways to test membership in a set of values. It
+ is also true that on some occasions, it is not only possible
+ to rewrite a query without a subquery, but it can be more
efficient to make use of some of these techniques rather than
to use subqueries. One of these is the <literal>IN()</literal>
construct:
@@ -12446,11 +12443,6 @@
Rewrite or drop the following paragraphs...
</remark>
- <remark role="note">
- Extra space inserted into "- -skip-column-names" to avoid XML
- parse error.
- </remark>
-
<!--
<para>
For more complicated subqueries, you can often create temporary
@@ -12487,11 +12479,10 @@
standard <literal>||</literal> operator). For example:
</para>
- <programlisting>
- SELECT
- CONCAT('DELETE FROM tab1 WHERE pkid = ', "'", tab1.pkid, "'", ';')
- FROM tab1, tab2
- WHERE tab1.col1 = tab2.col2;
+<programlisting>
+SELECT CONCAT('DELETE FROM tab1 WHERE pkid = ', "'", tab1.pkid, "'", ';')
+ FROM tab1, tab2
+ WHERE tab1.col1 = tab2.col2;
</programlisting>
<para>
@@ -12501,8 +12492,8 @@
<command>mysql</command>:
</para>
- <programlisting>
- shell> mysql - -skip-column-names mydb < myscript.sql | mysql mydb
+<programlisting>
+shell> mysql &ddash;skip-column-names mydb < myscript.sql | mysql mydb
</programlisting>
</itemizedlist>
Modified: trunk/refman-5.2/introduction.xml
===================================================================
--- trunk/refman-5.2/introduction.xml 2007-09-03 08:52:12 UTC (rev 7634)
+++ trunk/refman-5.2/introduction.xml 2007-09-03 09:18:51 UTC (rev 7635)
Changed blocks: 1, Lines Added: 1, Lines Deleted: 21; 1178 bytes
@@ -1388,28 +1388,8 @@
</itemizedlist>
- <section id="ansi-diff-subqueries">
+
- <title>Subquery Support</title>
-
- <para>
- MySQL 4.1 and up supports subqueries and derived tables. A
- <quote>subquery</quote> is a <literal>SELECT</literal>
- statement nested within another statement. A <quote>derived
- table</quote> (an unnamed view) is a subquery in the
- <literal>FROM</literal> clause of another statement. See
- <xref linkend="subqueries"/>.
- </para>
-
- <para>
- For MySQL versions older than 4.1, most subqueries can be
- rewritten using joins or other methods. See
- <xref linkend="rewriting-subqueries"/>, for examples that show
- how to do this.
- </para>
-
- </section>
-
<section id="ansi-diff-select-into-table">
<title><literal>SELECT INTO TABLE</literal></title>
Modified: trunk/refman-5.2/renamed-nodes.txt
===================================================================
--- trunk/refman-5.2/renamed-nodes.txt 2007-09-03 08:52:12 UTC (rev 7634)
+++ trunk/refman-5.2/renamed-nodes.txt 2007-09-03 09:18:51 UTC (rev 7635)
Changed blocks: 1, Lines Added: 1, Lines Deleted: 0; 569 bytes
@@ -27,6 +27,7 @@
access97-export myodbc-usagenotes-apptips-microsoft-access
ado myodbc-usagenotes-apptips-microsoft-ado
ado--rs-addnew myodbc-examples-programming-vb-ado
+ansi-diff-subqueries subqueries
answering-questions mailing-list-use
asking-questions bug-reports
asp myodbc-usagenotes-apptips-microsoft-asp
Modified: trunk/refman-5.2/sql-syntax.xml
===================================================================
--- trunk/refman-5.2/sql-syntax.xml 2007-09-03 08:52:12 UTC (rev 7634)
+++ trunk/refman-5.2/sql-syntax.xml 2007-09-03 09:18:51 UTC (rev 7635)
Changed blocks: 4, Lines Added: 11, Lines Deleted: 20; 2523 bytes
@@ -12905,14 +12905,11 @@
</indexterm>
<para>
- In previous versions of MySQL (prior to MySQL 4.1), only
- nested queries of the form <literal>INSERT ... SELECT
- ...</literal> and <literal>REPLACE ... SELECT ...</literal>
- were supported. Although this is not the case in MySQL
- ¤t-series;, it is still true that there are sometimes
- other ways to test membership in a set of values. It is also
- true that on some occasions, it is not only possible to
- rewrite a query without a subquery, but it can be more
+ Although MySQL ¤t-series; supports subqueries (see
+ <xref linkend="subqueries"/>), it is still true that there are
+ sometimes other ways to test membership in a set of values. It
+ is also true that on some occasions, it is not only possible
+ to rewrite a query without a subquery, but it can be more
efficient to make use of some of these techniques rather than
to use subqueries. One of these is the <literal>IN()</literal>
construct:
@@ -12971,11 +12968,6 @@
Rewrite or drop the following paragraphs...
</remark>
- <remark role="note">
- Extra space inserted into "- -skip-column-names" to avoid XML
- parse error.
- </remark>
-
<!--
<para>
For more complicated subqueries, you can often create temporary
@@ -13012,11 +13004,10 @@
standard <literal>||</literal> operator). For example:
</para>
- <programlisting>
- SELECT
- CONCAT('DELETE FROM tab1 WHERE pkid = ', "'", tab1.pkid, "'", ';')
- FROM tab1, tab2
- WHERE tab1.col1 = tab2.col2;
+<programlisting>
+SELECT CONCAT('DELETE FROM tab1 WHERE pkid = ', "'", tab1.pkid, "'", ';')
+ FROM tab1, tab2
+ WHERE tab1.col1 = tab2.col2;
</programlisting>
<para>
@@ -13026,8 +13017,8 @@
<command>mysql</command>:
</para>
- <programlisting>
- shell> mysql - -skip-column-names mydb < myscript.sql | mysql mydb
+<programlisting>
+shell> mysql &ddash;skip-column-names mydb < myscript.sql | mysql mydb
</programlisting>
</itemizedlist>
| Thread |
|---|
| • svn commit - mysqldoc@docsrva: r7635 - in trunk: refman-5.0 refman-5.1 refman-5.2 | jon | 3 Sep |
