Search This Blog

Thursday, July 29

Unlabelled Update all rows at a time

Update all rows at a time

by on

set @newid=100;

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

By at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)