[sqlite] any sql command to synchronize two table

op 10-11-2015 10:53 schreef YAN HONG YE op yanhong.ye at mpsa.com: > Hi, > I have two table with same field: > > Id int, > Content text, > Inserttime datatime, > Updatetime datatime > > I want to do this: > If id not in the other table, then insert it, > if id is same, and inserttime diffirent,

[sqlite] Worked in 3.8.9, but now "recursive aggregate queries not supported"

op 13-09-2015 01:45 schreef E.Pasma op pasma10 at concepts.nl: >> >> On 2015-09-13 12:40 AM, Aurel Wisse wrote: >>> @R.Smith >>> I wasn't aware that recursive aggregate queries give wrong answers >>> in 99% >>> of all general use cases//...

[sqlite] Third test of json and index expressions, now it works

op 06-09-2015 22:42 schreef Scott Robison op scott at casaderobison.com: > On Sun, Sep 6, 2015 at 10:54 AM, E.Pasma wrote: > >> >> Op 6 sep 2015, om 16:44 heeft Scott Robison het volgende geschreven: >> >>> >>> One, the argument wasn't whether or not column expressions were called >>>

Re: [sqlite] Different result from experimental query

The query should indeed return one row. Sorry I forget to say that. The NOT NULL for id in table t does not make any difference. It was only added to rule out that it might make any difference.. op 28-08-2013 16:29 schreef Marc L. Allen op mlal...@outsitenetworks.com: > Looks like that should