MySQL Forums
Forum List  »  Newbie

Re: How efficiently update frequency of words?
Posted by: Andrzej Borucki
Date: March 11, 2023 06:50AM

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?

Options: ReplyQuote

Written By
Re: How efficiently update frequency of words?
March 11, 2023 06:50AM

Sorry, only registered users may post in this forum.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.