Update I'd MySQL

 SET @id_value := 0;

UPDATE your_table_name

SET your_id_column = (@id_value := @id_value + 1)

WHERE @id_value <= 10;


Previous
Next Post »