Author: jstephens
Date: 2007-03-10 04:14:06 +0100 (Sat, 10 Mar 2007)
New Revision: 5295
Log:
Additional indexterms for subqueries (requested by Support)
Modified:
trunk/refman-4.1/sql-syntax.xml
trunk/refman-5.0/sql-syntax.xml
trunk/refman-5.1/sql-syntax.xml
Modified: trunk/refman-4.1/sql-syntax.xml
===================================================================
--- trunk/refman-4.1/sql-syntax.xml 2007-03-10 02:05:03 UTC (rev 5294)
+++ trunk/refman-4.1/sql-syntax.xml 2007-03-10 03:14:06 UTC (rev 5295)
Changed blocks: 7, Lines Added: 83, Lines Deleted: 0; 3712 bytes
@@ -8191,6 +8191,23 @@
<title>Subqueries with <literal>ANY</literal>, <literal>IN</literal>, and
<literal>SOME</literal></title>
+
+ <indexterm>
+ <primary>subqueries</primary>
+ <secondary>with ANY, IN, SOME</secondary>
+ </indexterm>
+
+ <indexterm>
+ <primary>ANY</primary>
+ </indexterm>
+
+ <indexterm>
+ <primary>IN</primary>
+ </indexterm>
+
+ <indexterm>
+ <primary>SOME</primary>
+ </indexterm>
<para>
Syntax:
@@ -8281,6 +8298,15 @@
<section id="all-subqueries">
<title>Subqueries with <literal>ALL</literal></title>
+
+ <indexterm>
+ <primary>subqueries</primary>
+ <secondary>with ALL</secondary>
+ </indexterm>
+
+ <indexterm>
+ <primary>ALL</primary>
+ </indexterm>
<para>
Syntax:
@@ -8373,6 +8399,19 @@
<section id="row-subqueries">
<title>Row Subqueries</title>
+
+ <indexterm>
+ <primary>row subqueries</primary>
+ </indexterm>
+
+ <indexterm>
+ <primary>ROW</primary>
+ </indexterm>
+
+ <indexterm>
+ <primary>subqueries</primary>
+ <secondary>with ROW</secondary>
+ </indexterm>
<para>
The discussion to this point has been of scalar or column
@@ -8428,6 +8467,26 @@
<section id="exists-and-not-exists-subqueries">
<title><literal>EXISTS</literal> and <literal>NOT EXISTS</literal></title>
+
+ <indexterm>
+ <primary>EXISTS</primary>
+ <secondary>with subqueries</secondary>
+ </indexterm>
+
+ <indexterm>
+ <primary>subqueries</primary>
+ <secondary>with EXISTS</secondary>
+ </indexterm>
+
+ <indexterm>
+ <primary>NOT EXISTS</primary>
+ <secondary>with subqueries</secondary>
+ </indexterm>
+
+ <indexterm>
+ <primary>subqueries</primary>
+ <secondary>with NOT EXISTS</secondary>
+ </indexterm>
<para>
If a subquery returns any rows at all, <literal>EXISTS
@@ -8521,6 +8580,15 @@
<section id="correlated-subqueries">
<title>Correlated Subqueries</title>
+
+ <indexterm>
+ <primary>correlated subqueries</primary>
+ </indexterm>
+
+ <indexterm>
+ <primary>subqueries</primary>
+ <secondary>correlated</secondary>
+ </indexterm>
<para>
A <emphasis>correlated subquery</emphasis> is a subquery that
@@ -8714,6 +8782,16 @@
<section id="subquery-errors">
<title>Subquery Errors</title>
+
+ <indexterm>
+ <primary>subqueries</primary>
+ <secondary>errors</secondary>
+ </indexterm>
+
+ <indexterm>
+ <primary>errors</primary>
+ <secondary>in subqueries</secondary>
+ </indexterm>
<para>
There are some errors that apply only to subqueries. This
@@ -9096,6 +9174,11 @@
<section id="rewriting-subqueries">
<title>Rewriting Subqueries as Joins for Earlier MySQL Versions</title>
+
+ <indexterm>
+ <primary>subqueries</primary>
+ <secondary>rewriting as joins</secondary>
+ </indexterm>
<para>
Before MySQL 4.1, only nested queries of the form
Modified: trunk/refman-5.0/sql-syntax.xml
===================================================================
--- trunk/refman-5.0/sql-syntax.xml 2007-03-10 02:05:03 UTC (rev 5294)
+++ trunk/refman-5.0/sql-syntax.xml 2007-03-10 03:14:06 UTC (rev 5295)
Changed blocks: 7, Lines Added: 83, Lines Deleted: 0; 3719 bytes
@@ -8855,6 +8855,23 @@
<title>Subqueries with <literal>ANY</literal>, <literal>IN</literal>, and
<literal>SOME</literal></title>
+
+ <indexterm>
+ <primary>subqueries</primary>
+ <secondary>with ANY, IN, SOME</secondary>
+ </indexterm>
+
+ <indexterm>
+ <primary>ANY</primary>
+ </indexterm>
+
+ <indexterm>
+ <primary>IN</primary>
+ </indexterm>
+
+ <indexterm>
+ <primary>SOME</primary>
+ </indexterm>
<para>
Syntax:
@@ -8945,6 +8962,15 @@
<section id="all-subqueries">
<title>Subqueries with <literal>ALL</literal></title>
+
+ <indexterm>
+ <primary>subqueries</primary>
+ <secondary>with ALL</secondary>
+ </indexterm>
+
+ <indexterm>
+ <primary>ALL</primary>
+ </indexterm>
<para>
Syntax:
@@ -9037,6 +9063,19 @@
<section id="row-subqueries">
<title>Row Subqueries</title>
+
+ <indexterm>
+ <primary>row subqueries</primary>
+ </indexterm>
+
+ <indexterm>
+ <primary>ROW</primary>
+ </indexterm>
+
+ <indexterm>
+ <primary>subqueries</primary>
+ <secondary>with ROW</secondary>
+ </indexterm>
<para>
The discussion to this point has been of scalar or column
@@ -9092,6 +9131,26 @@
<section id="exists-and-not-exists-subqueries">
<title><literal>EXISTS</literal> and <literal>NOT EXISTS</literal></title>
+
+ <indexterm>
+ <primary>EXISTS</primary>
+ <secondary>with subqueries</secondary>
+ </indexterm>
+
+ <indexterm>
+ <primary>subqueries</primary>
+ <secondary>with EXISTS</secondary>
+ </indexterm>
+
+ <indexterm>
+ <primary>NOT EXISTS</primary>
+ <secondary>with subqueries</secondary>
+ </indexterm>
+
+ <indexterm>
+ <primary>subqueries</primary>
+ <secondary>with NOT EXISTS</secondary>
+ </indexterm>
<para>
If a subquery returns any rows at all, <literal>EXISTS
@@ -9185,6 +9244,15 @@
<section id="correlated-subqueries">
<title>Correlated Subqueries</title>
+
+ <indexterm>
+ <primary>correlated subqueries</primary>
+ </indexterm>
+
+ <indexterm>
+ <primary>subqueries</primary>
+ <secondary>correlated</secondary>
+ </indexterm>
<para>
A <emphasis>correlated subquery</emphasis> is a subquery that
@@ -9379,6 +9447,16 @@
<section id="subquery-errors">
<title>Subquery Errors</title>
+
+ <indexterm>
+ <primary>subqueries</primary>
+ <secondary>errors</secondary>
+ </indexterm>
+
+ <indexterm>
+ <primary>errors</primary>
+ <secondary>in subqueries</secondary>
+ </indexterm>
<para>
There are some errors that apply only to subqueries. This
@@ -9761,6 +9839,11 @@
<section id="rewriting-subqueries">
<title>Rewriting Subqueries as Joins for Earlier MySQL Versions</title>
+
+ <indexterm>
+ <primary>subqueries</primary>
+ <secondary>rewriting as joins</secondary>
+ </indexterm>
<para>
In previous versions of MySQL (prior to MySQL 4.1), only
Modified: trunk/refman-5.1/sql-syntax.xml
===================================================================
--- trunk/refman-5.1/sql-syntax.xml 2007-03-10 02:05:03 UTC (rev 5294)
+++ trunk/refman-5.1/sql-syntax.xml 2007-03-10 03:14:06 UTC (rev 5295)
Changed blocks: 7, Lines Added: 83, Lines Deleted: 0; 3733 bytes
@@ -10490,6 +10490,23 @@
<title>Subqueries with <literal>ANY</literal>, <literal>IN</literal>, and
<literal>SOME</literal></title>
+
+ <indexterm>
+ <primary>subqueries</primary>
+ <secondary>with ANY, IN, SOME</secondary>
+ </indexterm>
+
+ <indexterm>
+ <primary>ANY</primary>
+ </indexterm>
+
+ <indexterm>
+ <primary>IN</primary>
+ </indexterm>
+
+ <indexterm>
+ <primary>SOME</primary>
+ </indexterm>
<para>
Syntax:
@@ -10580,6 +10597,15 @@
<section id="all-subqueries">
<title>Subqueries with <literal>ALL</literal></title>
+
+ <indexterm>
+ <primary>subqueries</primary>
+ <secondary>with ALL</secondary>
+ </indexterm>
+
+ <indexterm>
+ <primary>ALL</primary>
+ </indexterm>
<para>
Syntax:
@@ -10672,6 +10698,19 @@
<section id="row-subqueries">
<title>Row Subqueries</title>
+
+ <indexterm>
+ <primary>row subqueries</primary>
+ </indexterm>
+
+ <indexterm>
+ <primary>ROW</primary>
+ </indexterm>
+
+ <indexterm>
+ <primary>subqueries</primary>
+ <secondary>with ROW</secondary>
+ </indexterm>
<para>
The discussion to this point has been of scalar or column
@@ -10727,6 +10766,26 @@
<section id="exists-and-not-exists-subqueries">
<title><literal>EXISTS</literal> and <literal>NOT EXISTS</literal></title>
+
+ <indexterm>
+ <primary>EXISTS</primary>
+ <secondary>with subqueries</secondary>
+ </indexterm>
+
+ <indexterm>
+ <primary>subqueries</primary>
+ <secondary>with EXISTS</secondary>
+ </indexterm>
+
+ <indexterm>
+ <primary>NOT EXISTS</primary>
+ <secondary>with subqueries</secondary>
+ </indexterm>
+
+ <indexterm>
+ <primary>subqueries</primary>
+ <secondary>with NOT EXISTS</secondary>
+ </indexterm>
<para>
If a subquery returns any rows at all, <literal>EXISTS
@@ -10820,6 +10879,15 @@
<section id="correlated-subqueries">
<title>Correlated Subqueries</title>
+
+ <indexterm>
+ <primary>correlated subqueries</primary>
+ </indexterm>
+
+ <indexterm>
+ <primary>subqueries</primary>
+ <secondary>correlated</secondary>
+ </indexterm>
<para>
A <emphasis>correlated subquery</emphasis> is a subquery that
@@ -11014,6 +11082,16 @@
<section id="subquery-errors">
<title>Subquery Errors</title>
+
+ <indexterm>
+ <primary>subqueries</primary>
+ <secondary>errors</secondary>
+ </indexterm>
+
+ <indexterm>
+ <primary>errors</primary>
+ <secondary>in subqueries</secondary>
+ </indexterm>
<para>
There are some errors that apply only to subqueries. This
@@ -11396,6 +11474,11 @@
<section id="rewriting-subqueries">
<title>Rewriting Subqueries as Joins for Earlier MySQL Versions</title>
+
+ <indexterm>
+ <primary>subqueries</primary>
+ <secondary>rewriting as joins</secondary>
+ </indexterm>
<para>
In previous versions of MySQL (prior to MySQL 4.1), only
| Thread |
|---|
| • svn commit - mysqldoc@docsrva: r5295 - in trunk: refman-4.1 refman-5.0 refman-5.1 | jon | 10 Mar |
