On Sep 17, 2005, at 4:35 PM, Alexander J. Kozlovsky wrote:
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);
ahhh! the conflict algorithm. Thanks for drawing my attention to it... it should do the trick.
-- Puneet Kishor
