Listing 1. UPDATE That Generates a Range for Each Row's Weight

SET @start = 1
SET @lowerRangeCounter = 0
SET @upperRangeCounter = 0

UPDATE
  @versions
SET
  @lowerRangeCounter = Lower_Range = @lowerRangeCounter + @start,
  @start = page_weight,
@upperRangecounter = Upper_Range = @upperRangecounter + page_weight





1