先创建一张测试表
1 CREATE TABLE `test` ( 2 `id` int(11) DEFAULT NULL, 3 `count` int(11) DEFAULT NULL 4 ) ENGINE=InnoDB DEFAULT CHARSET=utf8
插入测试数据
1 insert into test (id, count) values(1000,1),(2000,2),(3000,3),(4000,4),(5000, 5),(6000,6),(7000,7),(8000,8),(9000,9); 2 insert into test (id, count) values(1100,1),(2100,