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 = 1
after the row withid = 3
and 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?
"Order"
column of your table to "move" the rows? – a_horse_with_no_name Feb 17 '20 at 9:13arrays
for this purpose? – Шариф Латипов Feb 17 '20 at 9:35