Wouldn't the mod operator do this?
Do an update and set key = 1 + (5 + key)%5
On 1/22/2018 12:38 PM, David Raymond wrote:
Unless I'm reading you wrong then just do the normal
begin transaction;
update playYouTubeVideo set speed = (
select speed from playYouTubeVideo where key = '2')
where key = '1';
update playYouTubeVideo set speed = (
select speed from playYouTubeVideo where key = '3')
where key = '2';
...
update playYouTubeVideo set speed = (
select speed from playYouTubeVideo where key = '5')
where key = '1';
commit;
-----Original Message-----
From: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] On
Behalf Of Cecil Westerhof
Sent: Monday, January 22, 2018 3:30 PM
To: SQLite mailing list
Subject: [sqlite] Can this be done with SQLite
I have the following table:
CREATE TABLE playYouTubeVideo (
key TEXT NOT NULL,
speed FLOAT NOT NULL,
CONSTRAINT key CHECK(length(key) == 1),
CONSTRAINT speed CHECK(TYPEOF(speed) = "real"),
PRIMARY KEY(key)
);
Say I want to rotate a part:
- The value by key '1' becomes the value by key '2'.
- The value by key '2' becomes the value by key '3'.
- The value by key '3' becomes the value by key '4'.
- The value by key '4' becomes the value by key '5'.
- The value by key '5' becomes the value by key '6'.
I suppose that I need to do this programmatically, or can this be done
with SQL?
And optionally also:
- The value by key '1' becomes the value by key '5'.
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
