PHP学院的中学生
- PHP学院的中学生 赞了回答
表结构:
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
- PHP学院的中学生 发表了说说$url = $protocol.$_SERVER['HTTP_HOST'].$_SERVER['REQUEST_URI'];
- PHP学院的中学生 发表了说说2019-05-17广东省签到
- PHP学院的中学生 2019-05-17 已签到连续签到5天,获得了20个金钱