Update all rows at a time Get link Facebook X Pinterest Email Other Apps July 29, 2021 set @newid=100; update order_details set child_order_id = (@newid:=@newid+1) order by ID; Read more