On 24 Sep 2013, at 6:58pm, Petite Abeille <petite.abei...@gmail.com> wrote:
> On Sep 24, 2013, at 7:54 PM, "Marc L. Allen" <mlal...@outsitenetworks.com> > wrote: > >> Yep. What most people want is an INSERT OR UPDATE. > > Yep. Which is what one usually calls 'MERGE': > > http://en.wikipedia.org/wiki/Merge_(SQL) > > And sadly, SQLite doesn't provide anything like that at all. Which is why you do an INSERT first, and allow it to fail, then do the UPDATE. Or do an UPDATE first and iff that fails, do an INSERT. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
