Question

Create a MySQL stored procedure which fetches the rows from a table by using a cursor?

Answer 1

To handle a result set inside a stored procedure, you use a cursor. A cursor allows you to iterate a set of rows returned by a query and process each row accordingly. MySQL cursor is read-only, non-scrollable and asensitive.