· 9 years ago · Oct 31, 2016, 11:04 PM
1SELECT count(*),time FROM `service_data` GROUP BY time
2
3CREATE TABLE IF NOT EXISTS `service_data` (
4 `id` int(11) NOT NULL AUTO_INCREMENT,
5 `service_id` varchar(255) NOT NULL,
6 `ip_address` varchar(255) NOT NULL,
7 `time` int(11) NOT NULL,
8 PRIMARY KEY (`id`)
9) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=5 ;