Passing an Array/Table to a stored Proc

[Joey JJ]

Hi, I couldn't find anything online regarding this.

If I generate an Array in Python/php, etc how can I pass the entire contents to a stored procedure in one go?

i.e. I want to

call the Stored Proc once
pass in all variables
perform a set of tasks

So I just want to run something like

CALL `TasksOnArray`(IN Array Table);

I believe this is possible in MS SQL by passing the array as a Table Type, but I'm less familiar with mySQL.

Thanks

Joey