Return to site

Mysql show databases just shows pointer on ubuntu

broken image

Read-only: you cannot update data in the underlying table through the cursor.

broken image

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

broken image

Summary: in this tutorial, you will learn how to use MySQL cursor in stored procedures to iterate through a result set returned by a SELECT statement.

broken image