Wim Verhaert wrote:
Is there any way to return multiple result variables from a stored
procedure? And I guess the answer is NO.
Or does anyone know how I can Concatenate (using the CONCAT function) to
glue together
my multiple results into one string that then can be post processed in
perl.
EG:
query on table names returns multiple names:
+-------------+
| Name |
+-------------+
| name1 |
| name2 |
| name3 |
+-------------+
now the result returned should look something like
name1::name2::name3
Thanks
Wim
If you can write your query with "group by", GROUP_CONCAT may help you:
http://dev.mysql.com/doc/mysql/en/GROUP-BY-Functions.html
HTH
Wolfram
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
