56,679
社区成员
发帖
与我相关
我的任务
分享
DROP TABLE IF EXISTS `log_test`;
CREATE TABLE `log_test` (
`id` int(11) NOT NULL,
`account` int(11) DEFAULT NULL,
`name` varchar(255) DEFAULT NULL,
`time` datetime DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP,
`count` int(11) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
INSERT INTO `log_test` VALUES ('1', '1001', 'aaa', '2017-11-08 14:01:30', '1');
INSERT INTO `log_test` VALUES ('2', '1001', 'aaa', '2017-11-08 14:01:34', '2');
INSERT INTO `log_test` VALUES ('3', '1001', 'bbb', '2017-11-08 14:01:41', '3');
INSERT INTO `log_test` VALUES ('4', '1002', 'ccc', '2017-11-08 14:08:49', '4');
INSERT INTO `log_test` VALUES ('5', '1002', 'ddd', '2017-11-08 14:09:23', '5');
select account, name, sum(count) from log_test group by account;
select account, max(name), sum(count) from log_test group by account;
select account, name, sum(count) from (select * from log_test order by time desc) as tmp group by account;
不知道还有什么更好的办法么