How to get a rowset from a stored procedure in MySQL 5.0?

[Konrad Karall]

Hi everybody!

I have to evaluate MySQL 5.0 for a new DB-project.

Does anyone has a idea how to get a Rowset from a stored procedure on a
MySQL-server 5.0

I have tried

CREATE PROCEDURE `get_data`()
SQL SECURITY INVOKER
COMMENT 'my first sp'
BEGIN
Select * from data1;
END

But when i execute the procedur i always get an error:
SELECT in a stored procedure must have INTO

The procedure above will work fine on Microsofts SQLServer 2000 - but how in
MySQL

I have researched the internet but found nothing.

Thank you for any comment.

[Bill Karwin]

Konrad Karall wrote:

CREATE PROCEDURE `get_data`()
SQL SECURITY INVOKER
COMMENT 'my first sp'
BEGIN
Select * from data1;
END

I'm still running MySQL 4.0, so I haven't done any MySQL procedures.
The feature is still very new (5.0 is in alpha), and the documentation
is pretty sparse.

But there are some good user comments with contributed examples
(including returning a result set) on the following web page:

http://dev.mysql.com/doc/mysql/en/St...rocedures.html

Regards,
Bill K.