Author: paul
Date: 2006-04-17 22:09:18 +0200 (Mon, 17 Apr 2006)
New Revision: 1845
Log:
r6707@polar: paul | 2006-04-17 13:09:13 -0500
Add SQLPS limitations.
Modified:
trunk/
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:6706
b5ec3a16-e900-0410-9ad2-d183a3acac99:/mysqldoc-local/mysqldoc/trunk:9486
bf112a9c-6c03-0410-a055-ad865cd57414:/mysqldoc-local/mysqldoc/trunk:4505
+ 4767c598-dc10-0410-bea0-d01b485662eb:/mysqldoc-local/mysqldoc/trunk:6707
b5ec3a16-e900-0410-9ad2-d183a3acac99:/mysqldoc-local/mysqldoc/trunk:9486
bf112a9c-6c03-0410-a055-ad865cd57414:/mysqldoc-local/mysqldoc/trunk:4505
Modified: trunk/refman-4.1/sql-syntax.xml
===================================================================
--- trunk/refman-4.1/sql-syntax.xml 2006-04-17 20:08:37 UTC (rev 1844)
+++ trunk/refman-4.1/sql-syntax.xml 2006-04-17 20:09:18 UTC (rev 1845)
@@ -19044,6 +19044,13 @@
<literal>DEALLOCATE PREPARE</literal> statement.
</para>
+ <para>
+ SQL syntax for prepared statements does not support
+ multi-statements (that is, multiple statements within a single
+ string separated by ‘<literal>;</literal>’
+ characters).
+ </para>
+
</section>
</chapter>
Modified: trunk/refman-5.0/sql-syntax.xml
===================================================================
--- trunk/refman-5.0/sql-syntax.xml 2006-04-17 20:08:37 UTC (rev 1844)
+++ trunk/refman-5.0/sql-syntax.xml 2006-04-17 20:09:18 UTC (rev 1845)
@@ -20956,6 +20956,12 @@
</programlisting>
<para>
+ As of MySQL 5.0.7, placeholders can be used for the arguments of
+ the <literal>LIMIT</literal> clause when using prepared
+ statements. See <xref linkend="select"/>.
+ </para>
+
+ <para>
SQL syntax for prepared statements cannot be used in nested
fashion. That is, a statement passed to <literal>PREPARE</literal>
cannot itself be a <literal>PREPARE</literal>,
@@ -20983,9 +20989,12 @@
</para>
<para>
- As of MySQL 5.0.7, placeholders can be used for the arguments of
- the <literal>LIMIT</literal> clause when using prepared
- statements. See <xref linkend="select"/>.
+ SQL syntax for prepared statements does not support
+ multi-statements (that is, multiple statements within a single
+ string separated by ‘<literal>;</literal>’
+ characters). This also means that prepared statements cannot
+ invoke stored procedures that return result sets, because prepared
+ statements do not support multiple result sets.
</para>
</section>
Modified: trunk/refman-5.1/sql-syntax.xml
===================================================================
--- trunk/refman-5.1/sql-syntax.xml 2006-04-17 20:08:37 UTC (rev 1844)
+++ trunk/refman-5.1/sql-syntax.xml 2006-04-17 20:09:18 UTC (rev 1845)
@@ -22366,6 +22366,12 @@
</programlisting>
<para>
+ Placeholders can be used for the arguments of the
+ <literal>LIMIT</literal> clause when using prepared statements.
+ See <xref linkend="select"/>.
+ </para>
+
+ <para>
SQL syntax for prepared statements cannot be used in nested
fashion. That is, a statement passed to <literal>PREPARE</literal>
cannot itself be a <literal>PREPARE</literal>,
@@ -22391,9 +22397,12 @@
</para>
<para>
- Placeholders can be used for the arguments of the
- <literal>LIMIT</literal> clause when using prepared statements.
- See <xref linkend="select"/>.
+ SQL syntax for prepared statements does not support
+ multi-statements (that is, multiple statements within a single
+ string separated by ‘<literal>;</literal>’
+ characters). This also means that prepared statements cannot
+ invoke stored procedures that return result sets, because prepared
+ statements do not support multiple result sets.
</para>
</section>
| Thread |
|---|
| • svn commit - mysqldoc@docsrva: r1845 - in trunk: . refman-4.1 refman-5.0 refman-5.1 | paul | 17 Apr |
