Re: [sqlite] Update multiple columns from subquery

[D. Richard Hipp]

Peter Bartholdsson wrote:
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;

Sadly, no.  SQLite only allows a subquery to return a single
value, not a tuple.
--
D. Richard Hipp -- [EMAIL PROTECTED] -- 704.948.4565