mysql> create table test (id int);
Query OK, 0 rows affected (0.37 sec)

mysql> insert into test select 11 union select 22 union select 33;
Query OK, 3 rows affected (0.02 sec)
Records: 3  Duplicates: 0  Warnings: 0

mysql> 
mysql> delimiter @@
mysql> create procedure test ()
    -> begin
    -> declare x int;
    -> declare cur cursor for select id from test;
    -> 
    -> open cur;
    -> fetch cur into x;
    -> select x x, found_rows() f;
    -> fetch cur into x;
    -> select x x, found_rows() f;
    -> close cur;
    -> 
    -> open cur;
    -> select 1 x union select 2 union select 3 union select 4;
    -> fetch cur into x;
    -> select x x, found_rows() f;
    -> fetch cur into x;
    -> select x x, found_rows() f;
    -> close cur;
    -> 
    -> end;
    -> @@
Query OK, 0 rows affected (0.00 sec)

mysql> delimiter ;
mysql> 
mysql> call test;
+------+---+
| x    | f |
+------+---+
|   11 | 3 |
+------+---+
1 row in set (0.03 sec)

+------+---+
| x    | f |
+------+---+
|   22 | 1 |
+------+---+
1 row in set (0.03 sec)

+---+
| x |
+---+
| 1 |
| 2 |
| 3 |
| 4 |
+---+
4 rows in set (0.04 sec)

+------+---+
| x    | f |
+------+---+
|   11 | 4 |
+------+---+
1 row in set (0.04 sec)

+------+---+
| x    | f |
+------+---+
|   22 | 7 |
+------+---+
1 row in set (0.05 sec)

Query OK, 0 rows affected (0.05 sec)

mysql> drop procedure test;
Query OK, 0 rows affected (0.00 sec)

mysql> drop table test;
Query OK, 0 rows affected (0.07 sec)

mysql> select * from test;
ERROR 1146 (42S02): Table 'test.test' doesnt exist
mysql> select found_rows();
+--------------+
| found_rows() |
+--------------+
|            8 |
+--------------+
1 row in set (0.00 sec)