Cursor and Prepared statement

[Rajarshi Biswas]

Is it possible to create a query using the prepared statement and use the prepared query in the Cursor, say creating a sql which is taking the table name dynamically as parameter on the procedure.
Do cursor support prepare statements .
If not then what is the alternative .

The code given below fails to compile as the error comes when the cursor is Declared



create procedure test(IN tablename varchar(255), IN columnname varchar(20))
BEGIN
SET @query = CONCAT ('SELECT ',columnname,' FROM ', tablename);
PREPARE stmt from @query;
BEGIN
DECLARE test_cursor CURSOR FOR stmt;
END;
END;
//


Pls suggest if the code has an alternative.