Search This Blog

Thursday, July 29

Update all rows at a time

set @newid=100;

update order_details set child_order_id = (@newid:=@newid+1) order by ID;

No comments:

Post a Comment