Fast way to Increment a column if another column exists?

Question

I have a database table with two columns:

CREATE TABLE Main(Id TEXT, Count INTEGER)

I'm currently using something like bellow code for adding a number to a column if it already exists :

query = SELECT * FROM Main WHERE Id=some_word LIMIT 1

if(query has some elements){
     UPDATE Main SET Count=query.count+word_count WHERE Id=some_word
}
else{
     INSERT INTO table_name SELECT some_word AS Id , word_Count AS Count 
     //some more UNION SELECT ...
}

How can I make those statements faster ?

score 0 · Answer 1 · edited May 23 '17 at 12:09

0

You can use INSERT ... ON DUPLICATE KEY UPDATE. For more information, look here.

edited May 23 '17 at 12:09

Community

1
1

answered Jun 01 '14 at 16:08

Nick Louloudakis

5,509
4
33
50

Note: I did not mark it as duplicate, as the question seems slightly different and for a different Database system. – Nick Louloudakis Jun 01 '14 at 16:11

Fast way to Increment a column if another column exists?

1 Answers1