I have a sqlite database and want to update the sort column in my table.
Col1 - Col2
C - 4
A - 3
B - 5
I want to sort on col1 then update Col2 with new values i.e. 1-3
Don't know if it's possible but doing it in code by looping and doing individual writes is a little slow.