strings (string, count)
select string, sum(count) from mytemp group by string;
As a complement to the "insert or replace" it would be nice to
have "insert or accumulate" for this kind of a job. However, that
would go outside of the SQL standard.
--
Lars Aronsson ([EMAI
fore I try this on the full size
German or English Wikipedia. But I might have to back down to the
Estonian or Faroese Wikipedia to get an even smaller dataset.
--
Lars Aronsson ([EMAIL PROTECTED])
Aronsson Datateknik - http://aronsson.se
___
?
Is there a good way to find out what sqlite3 is doing? I know the
"explain" command lists the byte code, but can it predict how long
an operation will take?
--
Lars Aronsson ([EMAIL PROTECTED])
Aronsson Datateknik - http://aronsson.se
___
sq
so full
transaction handling wasn't really needed. That shift in usage
pattern opened up for a simpler and more affordable solution.
Many other such technology shifts are described in an old book
titled "The Innovator's Dilemma".
--
Lars Aronsson ([EMAIL PROTECTED])
4 matches
Mail list logo