MySQl: triggering an insertion before updating, if the not existing

I'm 开发者_如何学Gonot really familiar with MySQL. But for performance reasons i want to avoid checking if a row already exists. Currently I've got a table with 2 columns (num, count) and I do something like this:

SELECT num FROM numbers WHERE num = 123

then if row exists...

UPDATE numbers SET count = count + 456 WHERE num = 123

else if row not exists...

INSERT INTO numbers (num, count) VALUES (123, 456)

Is there a possibility to avoid always querying the table. Something like a trigger... In the end, i just want to make an UPDATE, so that insertion is done automatically. thanks in advance

You don't need to use triggers, all you have to do is add UNIQUE constraint to your num column and then:

INSERT INTO numbers SET num = 123, count = 456 ON DUPLICATE KEY UPDATE count = count + 1;

Also, don't use reserved words for column names such as COUNT.