On 15 Jul 2010, at 2:34pm, Mark wrote: > when using INSERT, if the record is already present, will this cause any > problems, does it overwrite or ignore?
You can chose your own preference for each command: you can make the command generate an error, or replace the existing record, or be silently ignored, or other options. Take a look at http://www.sqlite.org/lang_insert.html INSERT OR REPLACE ... INSERT OR FAIL ... Note: the definition of 'record is already present' is that that it duplicates the UNIQUE keys of any existing record. This includes, but is not only, the PRIMARY KEY. Simon. _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
