mysql 单个if,MySQL如何在单个查询中执行if是否存在增量

I just wish to have a table to store a number of events by day.

Given a table:

create table totals (

entryday date,

total int(11) default 0 not null,

primary key (entryday) );

How can I write a simple query which increments, but creates an necessary?

I tried this - but it is not incrementing (it remains at 1):

REPLACE totals SET total = total + 1, entryday = "08-01-11"

Obviously this could be done in 2 queries quite simply, but it's through JDBC calls and may be called many times, so 1 query would be better.

解决方案

You probably want ON DUPLICATE KEY:

INSERT INTO totals (entryday, total)

VALUES ("08-01-11", 1)

ON DUPLICATE KEY UPDATE total = total + 1

That'll set the "08-01-11" total to 1 if a row doesn't already exist for that date and increment the total by 1 if it does.