On 2014/05/09 17:58, Drago, William @ MWG - NARDAEAST wrote:
-----Original Message-----
From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-
boun...@sqlite.org] On Behalf Of Igor Tandetnik
Sent: Thursday, May 08, 2014 9:48 AM
To: sqlite-users@sqlite.org
Subject: Re: [sqlite] duplicate row in sqlite3 database
On 5/8/2014 5:14 AM, techi eth wrote:
SQlite3 have any method where it can avoid adding duplicate row or
throwing error status code on duplication.,
Define a UNIQUE constraint or a unique index on those columns you don't
want duplicated. Then an attempt to insert a duplicate row would result
in an error.
An error as in program crash or an error code?
A returned error code which you can use to look up the meaning of (there are many possible things that might cause an error). If the
meaning turns out to be a failed constraint, then you know why the Insert did not complete.
If you do not particularly care for specifically the constraint failure, but just want the row inserted if it does not violate the
constraint, then one of two ways can be used, defining an ON CONFLICT clause in the schema or more generally used, the SQL syntax
"INSERT OR IGNORE INTO xxx... " which is much the same as INSERT with an ON CONFLICT IGNORE clause... details of all this can be
found on the conflict docs in the sqlite.org site.
http://www.sqlite.org/conflict.html
http://www.sqlite.org/lang_conflict.html
http://www.sqlite.org/lang_insert.html
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
