I have 2 tables
I have just added a ref column to allow me to reorder the list of child entries.
What I want to do for the existing data is update the new ref column.
So if there are 10 child items where the parent ID is 1 they the ref column to 1,2,3,...10.
if there are 5 child items with the parent ID of 2 they need to have the ref column set to 1,2,3,4,5
Any suggestions for a query to do this?
Thanks in advance