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.

Reply via email to