mysql 连续日期次数_mysql一个连续日期（天）次数的统计

首先声明参考：http://www.oschina.net/question/573517_118821

表定义

CREATE TABLE `date_add` (

`id` int(11) NOT NULL AUTO_INCREMENT,

`uid` int(11) NOT NULL DEFAULT ‘0‘,

`date` date NOT NULL,

PRIMARY KEY (`id`),

UNIQUE KEY `idx_ud` (`uid`,`date`)

) ENGINE=InnoDB AUTO_INCREMENT=23 DEFAULT CHARSET=latin1

插入语句

INSERT INTO `date_add` (`id`, `uid`, `date`) VALUES

(1, 1, ‘2015-09-01‘),

(2, 1, ‘2015-09-02‘),

(17, 1, ‘2015-09-03‘),

(18, 1, ‘2015-09-04‘),

(3, 2, ‘2015-09-01‘),

(4, 2, ‘2015-09-02‘),

(19, 2, ‘2015-09-03‘),

(20, 2, ‘2015-09-04‘),

(5, 3, ‘2015-09-01‘),

(6, 3, ‘2015-09-02‘),

(21, 3, ‘2015-09-03‘),

(22, 3, ‘2015-09-04‘),

(7, 4, ‘2015-09-01‘),