I've got the following table
And I have to change the order of the rows in an unpredictable way for example:
- Set the position of the row with
id = 1after the row with
id = 3and preserve the ordering of the other rows.
- Add new row at position 3 right after row with
id = 2.
- Delete row from position 4
What is the best solution for this problem?