zhengkx
- zhengkx 2019-05-28 已签到连续签到1天,获得了5个金钱
- zhengkx 2019-05-24 已签到连续签到1天,获得了5个金钱
- zhengkx 2019-05-18 已签到连续签到3天,获得了15个金钱
- zhengkx 2019-05-17 已签到连续签到2天,获得了10个金钱
问题不是很清楚。能提供表结构和一些实例数据吗
- zhengkx 2019-05-16 已签到连续签到1天,获得了5个金钱
- zhengkx 回答了问题 SQL 语句查询最大值
表结构:
CREATE TABLE `records` ( `id` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `date` datetime NULL DEFAULT NULL, PRIMARY KEY (`id`) USING BTREE ) ENGINE = MyISAM AUTO_INCREMENT = 6 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of records -- ---------------------------- INSERT INTO `records` VALUES (1, '张三', '2019-05-05 10:30:30'); INSERT INTO `records` VALUES (2, '张三', '2019-05-05 10:30:31'); INSERT INTO `records` VALUES (3, '张三', '2019-05-05 10:30:50'); INSERT INTO `records` VALUES (4, '张三', '2019-05-06 10:30:31'); INSERT INTO `records` VALUES (5, '张三', '2019-05-06 10:35:31');
查询语句:
select max(date), DATE_FORMAT(date, '%Y-%m-%d') as de from records GROUP BY de