查询每个人连续成功4次 mysql的
DROP TABLE IF EXISTS test
;
CREATE TABLE test
(Id
int(11) NOT NULL AUTO_INCREMENT,a
varchar(255) DEFAULT NULL,b
varchar(255) DEFAULT NULL,ctime
varchar(255) DEFAULT NULL,
PRIMARY KEY (Id
)
) ENGINE=MyISAM AUTO_INCREMENT=20 DEFAULT CHARSET=utf8;
#
Data for table "test"
#
/*!40000 ALTER TABLE test
DISABLE KEYS /;
INSERT INTO test
VALUES (1,'小王','成功','2017-03-01 00:00:00'),(2,'小王','成功','2017-03-02 00:00:00'),(3,'小王','成功','2017-03-01 00:00:00'),(4,'小王','成功','2017-03-02 00:00:00'),(5,'小李','成功','2017-03-03 00:00:00'),(6,'小张','失败','2017-03-04 00:00:00'),(7,'小李','失败','2017-03-05 00:00:00'),(8,'小红','失败','2017-03-06 00:00:00'),(9,'小张','失败','2017-03-07 00:00:00'),(10,'小红','成功','2017-03-08 00:00:00'),(11,'小李','成功','2017-03-05 00:00:00'),(12,'小红','成功','2017-03-08 00:00:00'),(13,'小红','成功','2017-03-08 00:00:00'),(14,'小红','成功','2017-03-08 00:00:00'),(15,'小红','成功','2017-03-08 00:00:00');
/!40000 ALTER TABLE test
ENABLE KEYS */;