Re: [sqlite] Inserting uniquely

On 20/ott/06, at 17:06, Lloyd wrote: Hi List, Is there is any easy way to insert a value to a table, if and only if it is not existing ? For example. If I have these values 1,2,3,4,1,2,3,4 when I insert these to a table it must be 1 2 3 4 [By using primary key or unique constraint, it

Re: [sqlite] Inserting uniquely

Lloyd wrote: Hi List, Is there is any easy way to insert a value to a table, if and only if it is not existing ? http://sqlite.org/lang_conflict.html ON CONFLICT clause conflict-clause ::= ON CONFLICT conflict-algorithm conflict-algorithm ::= ROLLBACK | ABORT | FAIL | IGNORE | REPLACE

[sqlite] Inserting uniquely

Hi List, Is there is any easy way to insert a value to a table, if and only if it is not existing ? For example. If I have these values 1,2,3,4,1,2,3,4 when I insert these to a table it must be 1 2 3 4 [By using primary key or unique constraint, it will work. But I dont want sqlite to