mysql 时间差内的数据_mysql查询时间段内的数据

先来建表语句：

SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------

-- Table structure for t_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', &#