mysql 动态游标_在MYSQL中使用动态SQL创建游标

I am writing a stored procedure which opens a cursor to a table and then iterate through all records. In the iterating process I create a dynamic query based on the results of first cursor. I need to open the cursor on dynamic sql, but MySQL is not allowing to do me so, as accoriding to the official doc of mysql "Cursors must be declared before declaring handlers. Variables and conditions must be declared before declaring either cursors or handlers". Here is the script

DELIMITER $$

DROP PROCEDURE IF EXISTS sp_test$$

CREATE PROCEDURE `sp_test`()

BEGIN

-- Declarations

DECLARE prepared_sql VARCHAR(1000);

DECLARE index_count INT;

-- Cursors

DECLARE cursor1 CURSOR FOR SELECT * from table1;

-- Conti