调用返回多行的mysql存储过程时出错

Question

I want write a stored procedure that return more than one row.

My stored procedure is (it is only an example)

DELIMITER $$

CREATE PROCEDURE get_users(out get_users varchar(30))
BEGIN
    select name into get_users from tbl_join;

END

Now I want to call the stored procedure and display result in phpmyadmin.

call get_users(@out);
select @out;

Then an error occured.

#1172 - Result consisted of more than one row

My table tbl_join is:

id    name      date

1     Anil     2000-09-12
2     Rahul    2001-02-04
3     Lijin    1999-12-21

Expected result is:

Anil
Rahul
Lijin

Simply I want a Stored Procedure for the above result. Please help me..

Answer 1

A query like this

select name into get_users from tbl_join;

is kind of pointless. In a relational database there is no order unless you specify it. In theory you could get another random row each time you execute this query. Write it like this

select name into get_users from tbl_join order by name limit 1;

to get the first name in alphabetical order, for example.