mysql 排序表
insert into express_order_stor_temp_source_statistics(id,receive_tel,source,num) SELECT @id :=@id + 1, t.* FROM ( SELECT t.receive_tel, t.source, count(1) FROM express_order_stor t WHERE t.`status` = 7 AND t.source IN (1, 2) AND t.update_time >= '2019-03-01' AND t.update_time < '2019-04-01' GROUP BY t.receive_tel, t.source ORDER BY count(1) DESC ) t, (SELECT @id := 0) f; CREATE TABLE `express_order_stor_temp_source_statistics` ( `id` int(11) NOT NULL COMMENT 'id', `receive_tel` varchar(50) COMMENT '收件人', `source` tinyint(2) COMMENT '订单来源', `num` int(8) COMMENT '数量', PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='xx统计表'; select * from express_order_stor_temp_source_statistics where id>1500000 limit 1000;