Doug-4 wrote:
>
> Wouldn't "INSERT OR REPLACE" do that for you? (which by the way, has to be
> one of the coolest features in SQLite of all!)
>
> http://www.sqlite.org/lang_insert.html
>
insert or replace deletes all rows that weren't specified in the query, i
don't know maybe in combination with select there's possible to so sth about
it - like that:
INSERT OR REPLACE INTO table (id).... then SELECT...
--
View this message in context:
http://www.nabble.com/one-liner-for-insert-or-update---tp25416164p25424616.html
Sent from the SQLite mailing list archive at Nabble.com.
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
