Re: Passing value beteen declared variables within cursor loop

[Rick James]

You can do that without a cursor. First verify that this does what you need:

SELECT  field1,
        @prev := IFNULL(id, @prev) AS id
    FROM ( SELECT @prev := 0 ) AS init
    JOIN tbl
    ORDER BY field1;

If that works, then ponder how to JOIN that to the existing table in a multi-table UPDATE.

SQL works best when it does thing en masse; it works poorly if you treat it like a regular programming language and use Cursors.