· 7 years ago · Sep 15, 2018, 12:12 AM
1Working with millions of MySQL rows
2CREATE TABLE IF NOT EXISTS `clicktime` (
3 `id` int(5) NOT NULL AUTO_INCREMENT,
4 `page` int(11) DEFAULT NULL,
5 `user` varchar(20) DEFAULT NULL,
6 `time` bigint(20) DEFAULT NULL,
7 PRIMARY KEY (`id`)
8) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=686277 ;
9
10SELECT time
11FROM clicktime
12WHERE `page` = '112'
13 AND `user` = 'admin'
14ORDER BY `id` ASC LIMIT 1