Re: [sqlite] Simple Select from IN - from a newbie.

[Kees Nuyt]

On Sat, 24 May 2014 22:24:01 +0200, RSmith <rsm...@rsweb.co.za> wrote:

> INSERT OR UPDATE TeamPersonTable (tpId,teamId,personId,orderId) 
> VALUES (1,3,4,0),(2,3,5,1),(3,7,4,1),(4,7,5,0);

That will raise a syntax error.

Make it:
INSERT OR REPLACE INTO TeamPersonTable
 (tpId,teamId,personId,orderId)
VALUES
 (1,3,4,0),(2,3,5,1),(3,7,4,1),(4,7,5,0);

or even:
REPLACE INTO TeamPersonTable
 (tpId,teamId,personId,orderId)
VALUES
 (1,3,4,0),(2,3,5,1),(3,7,4,1),(4,7,5,0);

http://www.sqlite.org/lang_insert.html

-- 
Groet, Cordialement, Pozdrawiam, Regards,

Kees Nuyt

_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users