Cursors in Mysql

When i am try to create a cursor with in a mysql stored procedure it is throwing syntax error in the create cursor line.Will any one please share mysql sample procedure with cursors usage on it?

The MySQL manual has example procedures with cursor usage:

MySQL :: MySQL 5.0 Reference Manual :: 12.7.5 Cursors

You might want to share some of your code and the exact error message if you want help with it.