bK9Vu4D3

1mysql> select * from tb_dts;
2+----+------+------+
3| Id | key1 | key2 |
4+----+------+------+
5|  1 |    1 |    1 |
6|  2 |    1 |    1 |
7|  3 |    1 |    1 |
8|  4 |    2 |    1 |
9|  5 |    2 |    1 |
10|  6 |    2 |    1 |
11|  7 |    2 |    1 |
12|  8 |    1 |    2 |
13|  9 |    1 |    2 |
14| 10 |    1 |    2 |
15| 11 |    1 |    2 |
16| 12 |    1 |    2 |
17| 13 |    3 |    1 |
18| 14 |    3 |    1 |
19| 15 |    3 |    1 |
20| 16 |    3 |    1 |
21| 17 |    2 |    2 |
22| 18 |    2 |    2 |
23| 19 |    2 |    2 |
24| 20 |    2 |    3 |
25| 21 |    2 |    3 |
26| 22 |    2 |    3 |
27| 23 |    3 |    2 |
28| 24 |    3 |    2 |
29| 25 |    3 |    2 |
30| 26 |    3 |    2 |
31+----+------+------+
3226 rows in set (0.00 sec)
33	
34mysql> select distinct key1,key2 from tb_dts limit 0,4;
35+------+------+
36| key1 | key2 |
37+------+------+
38|    1 |    1 |
39|    1 |    2 |
40|    2 |    1 |
41|    2 |    2 |
42+------+------+
434 rows in set (0.00 sec)
44
45mysql> select distinct key1,key2 from tb_dts limit 4,4;
46+------+------+
47| key1 | key2 |
48+------+------+
49|    2 |    3 |
50|    3 |    1 |
51|    3 |    2 |
52+------+------+
533 rows in set (0.00 sec)
54	
55mysql> select key1,key2,group_concat(Id) from tb_dts group by key1,key2 limit 0,4;
56+------+------+------------------+
57| key1 | key2 | group_concat(Id) |
58+------+------+------------------+
59|    1 |    1 | 1,2,3            |
60|    1 |    2 | 8,9,10,11,12     |
61|    2 |    1 | 4,5,6,7          |
62|    2 |    2 | 17,18,19         |
63+------+------+------------------+
644 rows in set (0.00 sec)
65
66mysql> select key1,key2,group_concat(Id) from tb_dts group by key1,key2 limit 4,4;
67+------+------+------------------+
68| key1 | key2 | group_concat(Id) |
69+------+------+------------------+
70|    2 |    3 | 20,21,22         |
71|    3 |    1 | 13,14,15,16      |
72|    3 |    2 | 23,24,25,26      |
73+------+------+------------------+
743 rows in set (0.00 sec)
75	
76select * from tb_dts where Id IN (1,2,3,8,9,10,11,12,4,5,6,7,17,18,19  )
77	
78select * from tb_dts where Id IN (20,21,22,13,14,15,16,23,24,25,26 )
79	
80DROP TABLE IF EXISTS `tb_dts`;
81CREATE TABLE `tb_dts` (
82  `Id` int(11) NOT NULL AUTO_INCREMENT,
83  `key1` int(11) DEFAULT '-99',
84  `key2` int(11) DEFAULT '-99',
85  PRIMARY KEY (`Id`),
86  KEY `main` (`key1`,`key2`)
87) ENGINE=MyISAM AUTO_INCREMENT=27 DEFAULT CHARSET=latin1;
88
89LOCK TABLES `tb_dts` WRITE;
90INSERT INTO `tb_dts` VALUES (1,1,1),(2,1,1),(3,1,1),(4,2,1),(5,2,1),(6,2,1),(7,2,1),(8,1,2),(9,1,2),(10,1,2),(11,1,2),(12,1,2),(13,3,1),(14,3,1),(15,3,1),(16,3,1),(17,2,2),(18,2,2),(19,2,2),(20,2,3),(21,2,3),(22,2,3),(23,3,2),(24,3,2),(25,3,2),(26,3,2);
91UNLOCK TABLES;
92	
93mysql> select Id from tb_dts group by key1,key2 limit 0,4;
94+----+
95| Id |
96+----+
97|  1 |
98|  8 |
99|  4 |
100| 17 |
101+----+
1024 rows in set (0.00 sec)
103	
104mysql> select key1,key2 from tb_dts group by key1,key2 limit 0,4;
105+------+------+
106| key1 | key2 |
107+------+------+
108|    1 |    1 |  --- 1,2,3
109|    1 |    2 |  --- 8,9,10,11,12
110|    2 |    1 |  --- 4,5,6,7 
111|    2 |    2 |  --- 17,18,19
112+------+------+
1134 rows in set (0.00 sec)
114	
1151
1162
1173
1188
1199
12010
12111
12212
1234
1245
1256
1267
12717
12818
12919