mysql 查询时间段 数据之和_MySQL 查询时间段内的数据

;-- ----------------------------

-- Table structure fort_user-- ----------------------------DROP TABLE IF EXISTS `t_user`;

CREATE TABLE `t_user` (

`userId` bigint(20) NOT NULL,

`fullName` varchar(64) NOT NULL,

`userType` varchar(16) NOT NULL,

`addedTime` datetime NOT NULL,

PRIMARY KEY (`userId`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8;-- ----------------------------

--Records of t_user-- ----------------------------INSERT INTO `t_user` VALUES (‘1‘, ‘爽爽‘, ‘普通‘, ‘2018-01-21 10:20:09‘);

INSERT INTO `t_user` VALUES (‘2‘, ‘贵贵‘, ‘普通‘, ‘2017-11-06 10:20:22‘);

INSERT INTO `t_user` VALUES (‘3‘, ‘芬芬‘, ‘vip‘, ‘2017-11-13 10:20:42‘);

INSERT INTO `t_user` VALUES (‘4‘, ‘思思‘, ‘vip‘, ‘2018-01-21 10:20:55‘);

INSERT INTO `t_user` VALUES (‘5‘, ‘妍妍‘, ‘vip‘,