Cecil, you need to make a backup of the values before they are altered, and then alter them from the backup. That way, by the time you have come full circle, you are not working with the changed values.
On Mon, Jan 22, 2018 at 4:11 PM, Cecil Westerhof <cldwester...@gmail.com> wrote: > 2018-01-22 23:07 GMT+01:00 Igor Tandetnik <i...@tandetnik.org>: > > > On 1/22/2018 4:36 PM, Cecil Westerhof wrote: > > > >> > >> When I do this, I get: > >> sqlite> SELECT * > >> ...> FROM playYouTubeVideo > >> ...> WHERE key BETWEEN '1' AND '5' > >> ...> ; > >> 1|1.0 > >> 2|2.0 > >> 3|3.0 > >> 4|4.0 > >> 5|5.0 > >> > >> [snip] > >> > >> sqlite> SELECT * > >> ...> FROM playYouTubeVideo > >> ...> WHERE key BETWEEN '1' AND '5' > >> ...> ; > >> 1|2.0 > >> 2|3.0 > >> 3|4.0 > >> 4|5.0 > >> 5|2.0 > >> > >> But I want the last one needs to be 1.0. > >> > > > > Something along these lines, perhaps: > > > > update playYouTubeVideo set key=char(61440+unicode(key)); > > update playYouTubeVideo set key=case when key=char(61440+unicode('1')) > > then '5' else char(unicode(key)-61440-1) end; > > > > This also expects the values to be constant. But what I want is that the > record with key 1 gets the value from key 2, with key 2 from key 3, … > > -- > Cecil Westerhof > _______________________________________________ > sqlite-users mailing list > sqlite-users@mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users