Call a stored procedure for each row returned by a query in MySQL
17:38 14 Jan 2013

I want a MySQL stored procedure which effectively does:

foreach id in (SELECT id FROM objects WHERE ... ) CALL testProc(id)

I think I simply want the MySQL answer to this question but I don't understand cursors well: How do I execute a stored procedure once for each row returned by query?

mysql stored-procedures