> Given: MySQL 4.0.12, I need to implement a pageview log with a
> resolution of 1 day.
>
> I propose this table:
>
> CREATE TABLE `pageviews` (
> `id` int(11) NOT NULL auto_increment,
> `date` date NOT NULL default '0000-00-00',
> `url` char(120) NOT NULL default '',
> `views` mediumint(9) NOT NULL default '0',
> PRIMARY KEY (`id`),
> UNIQUE KEY `date` (`date`,`url`),
> KEY `url` (`url`)
>) TYPE=InnoDB;>>>>>>
>
>
> So that an update will look like:
> > UPDATE pageviews SET views=views+1 WHERE date='<DATE>' AND
> url='<ARTIST>'
>
> Of course I need to INSERT the record if one does not match my WHERE.
> This would be easy if I had 4.1 -- "INSERT ... ON DUPLICATE KEY UPDATE",
> I think -- but I do not.

Would the "REPLACE" method work?

David