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.