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 will work. But I dont
want sqlite to throw error]
How can I get this done?
If you use INSERT OR IGNORE INTO table... you won't get any error
thrown by sqlite
-----------
Sergio 'OKreZ' Agosti
-----------
icq: 112421063
msn: [EMAIL PROTECTED]
skype: sergio.agosti
iChat: sergio.agosti
jabber: sergio.agosti
-----------
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------