Re: [sqlite] INSERTing a row only if it doesn't EXIST

[Alexander J. Kozlovsky]

> I want to avoid doing a two step process outside the db... I want to
> insert a row only if it doesn't exist already.

IMHO, if you table T1 have a unique key, you may do this

INSERT OR IGNORE T1 VALUES(1, 2, 3);


Best regards,
 Alexander                            mailto:[EMAIL PROTECTED]