如何将此MSSQL游标函数转换为MYSQL

DECLARE @cursor CURSOR;
DECLARE @id INT;
DECLARE @name VARCHAR(255);

SET @cursor = CURSOR FOR
SELECT id, name FROM table_name;

OPEN @cursor;

FETCH NEXT FROM @cursor INTO @id, @name;

WHILE @@FETCH_STATUS = 0
BEGIN
    -- 在此处执行相应的操作
    -- ...

    FETCH NEXT FROM @cursor INTO @id, @name;
END;

CLOSE @cursor;
DEALLOCATE @cursor;

DECLARE done INT DEFAULT FALSE;
DECLARE id INT;
DECLARE name VARCHAR(255);

DECLARE cursor_name CURSOR FOR
SELECT id, name FROM table_name;

DECLARE CONTINUE HANDLER FOR NOT FOUND SET done = TRUE;

OPEN cursor_name;

read_loop: LOOP
    FETCH cursor_name INTO id, name;
    IF done THEN
        LEAVE read_loop;
    END IF;

    -- 在此处执行相应的操作
    -- ...
END LOOP;

CLOSE cursor_name;