Re: How efficiently update frequency of words?

[Andrzej Borucki]

Update only one row:

update words set count = count+10 where word='dog' and pos='NOUN'

I possible some like:
UPDATE words
SET count = count + block_words.count
T2.c3 = expr
WHERE word = words.word AND pos = words.pos

How set not existing words in table copying from block_words?