Author: shinz
Date: 2006-11-08 12:06:00 +0100 (Wed, 08 Nov 2006)
New Revision: 3879
Log:
Stored procedures can return result sets, but stored functions cannot ( thanks, Markus Popp, for bringing this up; thanks, Paul, for clarifying! )
Modified:
trunk/refman-5.0/faqs.xml
trunk/refman-5.1/faqs.xml
Modified: trunk/refman-5.0/faqs.xml
===================================================================
--- trunk/refman-5.0/faqs.xml 2006-11-08 02:22:39 UTC (rev 3878)
+++ trunk/refman-5.0/faqs.xml 2006-11-08 11:06:00 UTC (rev 3879)
Changed blocks: 4, Lines Added: 21, Lines Deleted: 19; 3399 bytes
@@ -950,13 +950,14 @@
<answer>
<para>
- Yes. If you perform an ordinary <literal>SELECT</literal>
- inside a stored procedure or stored function, the result set
- is returned directly to the client. You need to use the
- MySQL 4.1 client-server protocol for this to work. This
- means that — for instance — in PHP, you need to
- use the <literal>mysqli</literal> extension rather than the
- old <literal>mysql</literal> extension.
+ <emphasis>Stored procedures</emphasis> can, but stored
+ functions cannot. If you perform an ordinary
+ <literal>SELECT</literal> inside a stored procedure, the
+ result set is returned directly to the client. You need to
+ use the MySQL 4.1 (or above) client-server protocol for this
+ to work. This means that — for instance — in
+ PHP, you need to use the <literal>mysqli</literal> extension
+ rather than the old <literal>mysql</literal> extension.
</para>
</answer>
@@ -1078,7 +1079,7 @@
<question>
<para>
- Can I print out a variable's value within a stored procedure
+ Can I print out a variable's value within a stored routine
for debugging purposes?
</para>
@@ -1087,13 +1088,15 @@
<answer>
<para>
- Yes. If you perform an ordinary <literal>SELECT</literal>
- inside a stored procedure or stored function, the result set
- is returned directly to the client. You will need to use the
- MySQL 4.1 client-server protocol for this to work. This
- means that — for instance — in PHP, you need to
- use the <literal>mysqli</literal> extension rather than the
- old <literal>mysql</literal> extension.
+ Yes, you can do this in a <emphasis>stored
+ procedure</emphasis>, but not in a stored function. If you
+ perform an ordinary <literal>SELECT</literal> inside a
+ stored procedure, the result set is returned directly to the
+ client. You will need to use the MySQL 4.1 (or above)
+ client-server protocol for this to work. This means that
+ — for instance — in PHP, you need to use the
+ <literal>mysqli</literal> extension rather than the old
+ <literal>mysql</literal> extension.
</para>
</answer>
@@ -6070,10 +6073,9 @@
<para>
If you are using Unicode (<literal>ucs2</literal> or
<literal>utf8</literal>), and you know what the Unicode sort
- order is (see
- <xref linkend="faqs-cjk"/>), but
- MySQL still seems to sort your table incorrectly, then you
- should first verify the table character set:
+ order is (see <xref linkend="faqs-cjk"/>), but MySQL still
+ seems to sort your table incorrectly, then you should first
+ verify the table character set:
<programlisting>
mysql> <userinput>SHOW CREATE TABLE t\G</userinput>
Modified: trunk/refman-5.1/faqs.xml
===================================================================
--- trunk/refman-5.1/faqs.xml 2006-11-08 02:22:39 UTC (rev 3878)
+++ trunk/refman-5.1/faqs.xml 2006-11-08 11:06:00 UTC (rev 3879)
Changed blocks: 4, Lines Added: 21, Lines Deleted: 19; 3399 bytes
@@ -948,13 +948,14 @@
<answer>
<para>
- Yes. If you perform an ordinary <literal>SELECT</literal>
- inside a stored procedure or stored function, the result set
- is returned directly to the client. You need to use the
- MySQL 4.1 client-server protocol for this to work. This
- means that — for instance — in PHP, you need to
- use the <literal>mysqli</literal> extension rather than the
- old <literal>mysql</literal> extension.
+ <emphasis>Stored procedures</emphasis> can, but stored
+ functions cannot. If you perform an ordinary
+ <literal>SELECT</literal> inside a stored procedure, the
+ result set is returned directly to the client. You need to
+ use the MySQL 4.1 (or above) client-server protocol for this
+ to work. This means that — for instance — in
+ PHP, you need to use the <literal>mysqli</literal> extension
+ rather than the old <literal>mysql</literal> extension.
</para>
</answer>
@@ -1076,7 +1077,7 @@
<question>
<para>
- Can I print out a variable's value within a stored procedure
+ Can I print out a variable's value within a stored routine
for debugging purposes?
</para>
@@ -1085,13 +1086,15 @@
<answer>
<para>
- Yes. If you perform an ordinary <literal>SELECT</literal>
- inside a stored procedure or stored function, the result set
- is returned directly to the client. You will need to use the
- MySQL 4.1 client-server protocol for this to work. This
- means that — for instance — in PHP, you need to
- use the <literal>mysqli</literal> extension rather than the
- old <literal>mysql</literal> extension.
+ Yes, you can do this in a <emphasis>stored
+ procedure</emphasis>, but not in a stored function. If you
+ perform an ordinary <literal>SELECT</literal> inside a
+ stored procedure, the result set is returned directly to the
+ client. You will need to use the MySQL 4.1 (or above)
+ client-server protocol for this to work. This means that
+ — for instance — in PHP, you need to use the
+ <literal>mysqli</literal> extension rather than the old
+ <literal>mysql</literal> extension.
</para>
</answer>
@@ -6069,10 +6072,9 @@
<para>
If you are using Unicode (<literal>ucs2</literal> or
<literal>utf8</literal>), and you know what the Unicode sort
- order is (see
- <xref linkend="faqs-cjk"/>), but
- MySQL still seems to sort your table incorrectly, then you
- should first verify the table character set:
+ order is (see <xref linkend="faqs-cjk"/>), but MySQL still
+ seems to sort your table incorrectly, then you should first
+ verify the table character set:
<programlisting>
mysql> <userinput>SHOW CREATE TABLE t\G</userinput>
| Thread |
|---|
| • svn commit - mysqldoc@docsrva: r3879 - in trunk: refman-5.0 refman-5.1 | stefan | 8 Nov |
