MySQL stored procedures out variable as array

Question

I have MySQL procedure where I want to get a result of query:

SELECT id FROM mbus_clients WHERE second_name like surnamePart AS

So it should be an array. The decision I've found in the internet is to use temporary table. But how can I return a table and read with PHP? Is it ok?

Barmar · Accepted Answer · 2014-08-29 16:30:55Z

2

Simply call the procedure:

CALL procedurename();

If the procedure performs a SELECT, the result set of the procedure call will be the same as if you'd performed the query itself. You can then fetch the rows using PHP the same way as if you'd performed a SELECT.

answered Aug 29, 2014 at 16:30

Barmar

789k57 gold badges554 silver badges669 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Sergey Scopin Over a year ago

But i should use the first element of this array in procedure. Actually it should return two output variables and both should be array. Is it possible?

Barmar Over a year ago

There's no such thing as arrays in MySQL.

Collectives™ on Stack Overflow

MySQL stored procedures out variable as array

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related