DELIMITER //

create procedure spider_upgrade()

`spider_upgrade`: BEGIN

 DECLARE done INTEGER DEFAULT 0;

    DECLARE schema_table VARCHAR(100) CHARACTER SET utf8 DEFAULT "";

    DECLARE table_list CURSOR FOR select concat('`', table_schema,'`.`',table_name,'`') from information_schema.tables where engine='spider';

    DECLARE CONTINUE HANDLER FOR NOT FOUND SET done = 1;

    OPEN table_list;

    tlist: LOOP

        FETCH table_list INTO schema_table;

        IF done = 1 THEN LEAVE tlist;

        END IF;

        SET @sql_query = concat('ALTER TABLE ', schema_table, ' engine=spider');

        PREPARE stmt FROM @sql_query;

        EXECUTE stmt;

        DEALLOCATE PREPARE stmt;

    END LOOP;

END //

DELIMITER ;