Mysql – How to create a stored procedure that iterates through a table and pass the id to another stored procedure?
I have an enormous orders table that I need to purge having certain city_id's. I created a stored procedure that accepts 1 parameter and deletes 10,000 records at a time and it works well. The city_id's come from a table…