hello once more
i wander how to do this query:
insert into tablename values ('word')
but if does not exist the same word in other table
i suppose that with combination of your answers to this and my other post
solution can be created, but i do not know how exactly :)
thanx
vl.pavlov wrote:
>
> dear Dennis
>
> thank u 4 reply once more, i'll try with your suggestion
>
> vl
>
>
> Dennis Cote wrote:
>>
>> vl.pavlov wrote:
>>>
>>> i wander how 2 check (efficiently) if some word (string, in c++) exist
>>> in
>>> the sqlite3 table
>>>
>>
>> Assuming this is the same database as your last question. You have the
>> table:
>>
>> create table words (word text primary key, number integer);
>>
>> Then this query will work:
>>
>> select exists (select * from words where word = :word);
>>
>> HTH
>> Dennis Cote
>> _______________________________________________
>> sqlite-users mailing list
>> sqlite-users@sqlite.org
>> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>>
>>
>
>
--
View this message in context:
http://www.nabble.com/newB-question--c%2B%2B-and-sqlite3--how2-check-if-word-exist-in-the-table-tp15758100p15950680.html
Sent from the SQLite mailing list archive at Nabble.com.
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
