Re: Passing an Array/Table to a stored Proc

[Joey JJ]

Thanks for the reply. I understand that there are no arrays in mysql but the result will come from Python in an array. So I had planned to insert into a temporary table, then pass the table to a Proc, like the below.

However the below code gives an error:

CREATE PROCEDURE `new_procedure` (IN tmp TABLE)
BEGIN

	SELECT * FROM tmp;

END

Thanks for any help you can give