Is there some way to write this query in SQLite? UPDATE groups SET (fileCount, size) = (SELECT count(id), sum(size) FROM files where groupId = 15) WHERE groupId = 15;
Or must it be written like this? UPDATE groups SET fileCount = (SELECT count(id) FROM files where groupId = 15), size = (SELECT sum(size) FROM files where groupId = 15) WHERE groupId = 15;
I mostly want to get the two selects into one and I can't place code between the two.