核心算法代码分享如下:
/*
Navicat MySQL Data Transfer
Source Server : localhost_3306
Source Server Version : 50728
Source Host : localhost:3306
Source Database : hive_earthquake
Target Server Type : MYSQL
Target Server Version : 50728
File Encoding : 65001
Date: 2024-05-09 22:51:58
*/
SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for table01
-- ----------------------------
DROP TABLE IF EXISTS `table01`;
CREATE TABLE `table01` (
`sheng` text COLLATE utf8mb4_bin,
`num` bigint(20) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;
-- ----------------------------
-- Records of table01
-- ----------------------------
INSERT INTO `table01` VALUES (0xE696B0E79686, '2651');
INSERT INTO `table01` VALUES (0xE5B9BFE8A5BF, '30');
INSERT INTO `table01` VALUES (0xE6B5B7E58D97, '8');
INSERT INTO `table01` VALUES (0xE99995E8A5BF, '48');
INSERT INTO `table01` VALUES (0xE5AE81E5A48F, '50');
INSERT INTO `table01` VALUES (0xE6B19FE88B8F, '39');
INSERT INTO `table01` VALUES (0xE5A4A9E6B4A5, '14');
INSERT INTO `table01` VALUES (0xE9BB91E9BE99E6B19F, '27');
INSERT INTO `table01` VALUES (0xE4BA91E58D97, '792');
INSERT INTO `table01` VALUES (0xE58685E89299E58FA4, '157');
INSERT INTO `table01` VALUES (0xE5B9BFE4B89C, '82');
INSERT INTO `table01` VALUES (0xE7A68FE5BBBA, '28');
INSERT INTO `table01` VALUES (0xE8A5BFE8978F, '865');
INSERT INTO `table01` VALUES (0xE99D92E6B5B7, '556');
INSERT INTO `table01` VALUES (0xE6B996E58C97, '30');
INSERT INTO `table01` VALUES (0xE9878DE5BA86, '42');
INSERT INTO `table01` VALUES (0xE8B4B5E5B79E, '47');
INSERT INTO `table01` VALUES (0xE6B2B3E58D97, '20');
INSERT INTO `table01` VALUES (0xE8BEBDE5AE81, '87');
INSERT INTO `table01` VALUES (0xE5B1B1E8A5BF, '66');
INSERT INTO `table01` VALUES (0xE6B996E58D97, '8');
INSERT INTO `table01` VALUES (0xE58FB0E6B9BE, '661');
INSERT INTO `table01` VALUES (0xE6B19FE8A5BF, '8');
INSERT INTO `table01` VALUES (0xE6B599E6B19F, '26');
INSERT INTO `table01` VALUES (0xE79498E88283, '188');
INSERT INTO `table01` VALUES (0xE5B1B1E4B89C, '64');
INSERT INTO `table01` VALUES (0xE6B2B3E58C97, '195');
INSERT INTO `table01` VALUES (0xE59B9BE5B79D, '1236');
INSERT INTO `table01` VALUES (0xE58C97E4BAAC, '24');
INSERT INTO `table01` VALUES (0xE59089E69E97, '78');
INSERT INTO `table01` VALUES (0xE5AE89E5BEBD, '29');