Populating columns with sequential values

[Michael Smith]

I am trying to populate a column (order2) with sequential values (10,20,30 ...) where the table is ordered on the values in order1 .

I have come up with code as below:

Select * from products01 order by order1;
SELECT @i:=0;
UPDATE products01 SET order2 = @i:=@i+10;

The products file is naturally ordered on the product number with auto-increment.

I am unable to get the table to order by order1 while I populate order2.

Any thoughts?

Mike Smith