How should I design a specific needs mysql table
I suggest you create a table with the following fields:


Page URL
Date (Not datetime)
Count


And add a unique key on (page_url, date).

Then, use INSERT INTO .. ON DUPLICATE KEY UPDATE.

So, 

CREATE TABLE `page_view` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `page_url` varchar(512) NOT NULL,
  `date` date NOT NULL,
  `count` int(10) unsigned NOT NULL DEFAULT '1',
  PRIMARY KEY (`id`),
  UNIQUE KEY `page_url` (`page_url`,`date`)
)


Then, use this insert:

INSERT INTO page_view (page_url, date) 
VALUES ('www.example.com/page1.html', date(now())) 
ON DUPLICATE KEY UPDATE count=count+1;