How should I shift values to one place back in SqLite?

0 votes

1 answer

636 views

sqlite

                          I have a SqLite DB in which i have 16 columns as id, and f1 to f15.

Now Mistakenly I entered data from 2 column,  leaving the first one empty. Now my all values are one place ahead i.e value of last column of first row is in 1st column of 2nd row. 

Now I wish to correct this so that all values at their right place . Any query for this problem?

Asked by PRADHYUMN SHARMA (9 rep)

Nov 3, 2020, 03:32 AM
Last activity: Jul 23, 2025, 05:03 AM

How should I shift values to one place back in SqLite?

Related Questions