sqlite: Move one column in the row to the third row after (for the whole database) sqlite

samedi 27 décembre 2014

I have big database with few columns ex. ID, SomeID, t1, aa, bb, cc.

What I want to achieve is for all rows to move the column SomeID three rows lower.

Example :


  ID    SomeID, t1, aa..
  1   , Text1,   some,some...
  2   , Text2,   some,some...
  3   , Text3,   some,some...
  4   , Text4,   some,some...

and after the SQL command the text1 go be in column SomeID with ID 3, and text2 to be in column SomeID with ID 4

Can anyone refer where can I find such a command?

sqlite