mysql数字开头字符串排序

最新推荐文章于 2024-06-25 01:52:58 发布
最新推荐文章于 2024-06-25 01:52:58 发布
阅读量358 收藏
点赞数
文章标签： mysql 数据库
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/weixin_45352783/article/details/131783679
版权

表结构

CREATE TABLE `building` (
  `id` bigint NOT NULL,
  `name` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8_general_ci DEFAULT NULL COMMENT '名称',
  `full_name` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8_general_ci DEFAULT NULL COMMENT '全称',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 ROW_FORMAT=DYNAMIC COMMENT='楼层房屋管理';

表数据

/*
 Navicat Premium Data Transfer

 Source Server         : local
 Source Server Type    : MySQL
 Source Server Version : 80029
 Source Host           : localhost:3306
 Source Schema         : mcs_saas

 Target Server Type    : MySQL
 Target Server Version : 80029
 File Encoding         : 65001

 Date: 18/07/2023 11:32:43
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for building
-- ----------------------------
DROP TABLE IF EXISTS `building`;
CREATE TABLE `building`  (
  `id` bigint(0) NOT NULL,
  `name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '名称',
  `full_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '全称',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '楼栋楼层房屋管理' ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of building
-- ----------------------------
INSERT INTO `building` VALUES (1676071865075941377, '1栋', '1栋');
INSERT INTO `building` VALUES (1676071865084329985, '2栋', '2栋');
INSERT INTO `building` VALUES (1676071865084329986, '5栋', '5栋');
INSERT INTO `building` VALUES (1676071865084329987, '3栋', '3栋');
INSERT INTO `building` VALUES (1676071865084329988, '1楼', '3栋1楼');
INSERT INTO `building` VALUES (1676071865084329989, '101', '3栋1楼101');
INSERT INTO `building` VALUES (1676071865084329990, '102', '3栋1楼102');
INSERT INTO `building` VALUES (1676071865084329991, '2楼', '3栋2楼');
INSERT INTO `building` VALUES (1676071865084329992, '201', '3栋2楼201');
INSERT INTO `building` VALUES (1676071865084329993, '202', '3栋2楼202');
INSERT INTO `building` VALUES (1676071865084329994, '3楼', '3栋3楼');
INSERT INTO `building` VALUES (1676071865084329995, '301', '3栋3楼301');
INSERT INTO `building` VALUES (1676071865084329996, '302', '3栋3楼302');
INSERT INTO `building` VALUES (1676071865084329997, '4楼', '3栋4楼');
INSERT INTO `building` VALUES (1676071865084329998, '401', '3栋4楼401');
INSERT INTO `building` VALUES (1676071865084329999, '402', '3栋4楼402');
INSERT INTO `building` VALUES (1676071865084330000, '5楼', '3栋5楼');
INSERT INTO `building` VALUES (1676071865084330001, '501', '3栋5楼501');
INSERT INTO `building` VALUES (1676071865084330002, '502', '3栋5楼502');
INSERT INTO `building` VALUES (1676071865084330003, '4栋', '4栋');
INSERT INTO `building` VALUES (1676476815827861507, '7栋', '7栋');
INSERT INTO `building` VALUES (1676476815827861508, '2楼', '7栋2楼');
INSERT INTO `building` VALUES (1676476815827861509, '2-1', '7栋2楼2-1');
INSERT INTO `building` VALUES (1676476815827861510, '2-2', '7栋2楼2-2');
INSERT INTO `building` VALUES (1676476815827861511, '3楼', '7栋3楼');
INSERT INTO `building` VALUES (1676476815827861512, '3-1', '7栋3楼3-1');
INSERT INTO `building` VALUES (1676476815827861513, '3-2', '7栋3楼3-2');
INSERT INTO `building` VALUES (1676476815827861514, '4楼', '7栋4楼');
INSERT INTO `building` VALUES (1676476815827861515, '4-1', '7栋4楼4-1');
INSERT INTO `building` VALUES (1676476815827861516, '4-2', '7栋4楼4-2');
INSERT INTO `building` VALUES (1676476815827861517, '1栋', '1栋');
INSERT INTO `building` VALUES (1676476815827861518, '2楼', '1栋2楼');
INSERT INTO `building` VALUES (1676476815827861519, '2-1', '1栋2楼2-1');
INSERT INTO `building` VALUES (1676476815827861520, '2-2', '1栋2楼2-2');
INSERT INTO `building` VALUES (1676476815827861521, '2-3', '1栋2楼2-3');
INSERT INTO `building` VALUES (1676476815827861522, '2-4', '1栋2楼2-4');
INSERT INTO `building` VALUES (1676476815827861523, '3楼', '1栋3楼');
INSERT INTO `building` VALUES (1676476815827861524, '3-1', '1栋3楼3-1');
INSERT INTO `building` VALUES (1676476815827861525, '3-2', '1栋3楼3-2');
INSERT INTO `building` VALUES (1676476815827861526, '3-3', '1栋3楼3-3');
INSERT INTO `building` VALUES (1676476815827861527, '4楼', '1栋4楼');
INSERT INTO `building` VALUES (1676476815827861528, '4-1', '1栋4楼4-1');
INSERT INTO `building` VALUES (1676476815827861529, '4-2', '1栋4楼4-2');
INSERT INTO `building` VALUES (1676476815827861530, '4-3', '1栋4楼4-3');
INSERT INTO `building` VALUES (1676476815827861531, '5楼', '1栋5楼');
INSERT INTO `building` VALUES (1676476815827861532, '5-1', '1栋5楼5-1');
INSERT INTO `building` VALUES (1676476815827861533, '5-2', '1栋5楼5-2');
INSERT INTO `building` VALUES (1676476815827861534, '5-3', '1栋5楼5-3');
INSERT INTO `building` VALUES (1676476815827861535, '5-4', '1栋5楼5-4');
INSERT INTO `building` VALUES (1676476815827861536, '6楼', '1栋6楼');
INSERT INTO `building` VALUES (1676476815827861537, '6-1', '1栋6楼6-1');
INSERT INTO `building` VALUES (1676476815827861538, '6-2', '1栋6楼6-2');
INSERT INTO `building` VALUES (1676476815827861539, '6-3', '1栋6楼6-3');
INSERT INTO `building` VALUES (1676476815827861540, '6-4', '1栋6楼6-4');
INSERT INTO `building` VALUES (1676476815827861541, '7楼', '1栋7楼');
INSERT INTO `building` VALUES (1676476815827861542, '7-1', '1栋7楼7-1');
INSERT INTO `building` VALUES (1676476815827861543, '7-2', '1栋7楼7-2');
INSERT INTO `building` VALUES (1676476815827861544, '7-3', '1栋7楼7-3');
INSERT INTO `building` VALUES (1676476815827861545, '7-4', '1栋7楼7-4');
INSERT INTO `building` VALUES (1676476815827861546, '7-5', '1栋7楼7-5');
INSERT INTO `building` VALUES (1676476815827861547, '8楼', '1栋8楼');
INSERT INTO `building` VALUES (1676476815827861548, '8-1', '1栋8楼8-1');
INSERT INTO `building` VALUES (1676476815827861549, '8-2', '1栋8楼8-2');
INSERT INTO `building` VALUES (1676476815827861550, '8-3', '1栋8楼8-3');
INSERT INTO `building` VALUES (1676476815827861551, '8-4', '1栋8楼8-4');
INSERT INTO `building` VALUES (1676476815827861552, '3栋', '3栋');
INSERT INTO `building` VALUES (1676476815827861553, '2楼', '3栋2楼');
INSERT INTO `building` VALUES (1676476815827861556, '3楼', '3栋3楼');
INSERT INTO `building` VALUES (1676476815827861559, '4楼', '3栋4楼');
INSERT INTO `building` VALUES (1676476815827861560, '4-1', '3栋4楼4-1');
INSERT INTO `building` VALUES (1676476815827861561, '4-2', '3栋4楼4-2');
INSERT INTO `building` VALUES (1676476815827861562, '2栋', '2栋');
INSERT INTO `building` VALUES (1676476815827861563, '2楼', '2栋2楼');
INSERT INTO `building` VALUES (1676476815827861564, '2-1', '2栋2楼2-1');
INSERT INTO `building` VALUES (1676476815827861565, '2-2', '2栋2楼2-2');
INSERT INTO `building` VALUES (1676476815827861566, '2-3', '2栋2楼2-3');
INSERT INTO `building` VALUES (1676476815827861567, '2-4', '2栋2楼2-4');
INSERT INTO `building` VALUES (1676476815827861568, '2-5', '2栋2楼2-5');
INSERT INTO `building` VALUES (1676476815827861569, '2-6', '2栋2楼2-6');
INSERT INTO `building` VALUES (1676476815827861570, '3楼', '2栋3楼');
INSERT INTO `building` VALUES (1676476815827861571, '3-1', '2栋3楼3-1');
INSERT INTO `building` VALUES (1676476815827861572, '3-2', '2栋3楼3-2');
INSERT INTO `building` VALUES (1676476815827861573, '4楼', '2栋4楼');
INSERT INTO `building` VALUES (1676476815827861574, '4-1', '2栋4楼4-1');
INSERT INTO `building` VALUES (1676476815827861575, '4-2', '2栋4楼4-2');
INSERT INTO `building` VALUES (1676476815827861576, '5栋', '5栋');
INSERT INTO `building` VALUES (1676476815827861577, '2楼', '5栋2楼');
INSERT INTO `building` VALUES (1676476815827861578, '2-1', '5栋2楼2-1');
INSERT INTO `building` VALUES (1676476815827861579, '2-2', '5栋2楼2-2');
INSERT INTO `building` VALUES (1676476815827861580, '2-3', '5栋2楼2-3');
INSERT INTO `building` VALUES (1676476815827861581, '3楼', '5栋3楼');
INSERT INTO `building` VALUES (1676476815827861582, '3-1', '5栋3楼3-1');
INSERT INTO `building` VALUES (1676476815827861583, '3-2', '5栋3楼3-2');
INSERT INTO `building` VALUES (1676476815827861584, '3-3', '5栋3楼3-3');
INSERT INTO `building` VALUES (1676476815827861585, '4楼', '5栋4楼');
INSERT INTO `building` VALUES (1676476815827861586, '4-1', '5栋4楼4-1');
INSERT INTO `building` VALUES (1676476815827861587, '4-2', '5栋4楼4-2');
INSERT INTO `building` VALUES (1676476815827861588, '6栋', '6栋');
INSERT INTO `building` VALUES (1676476815827861589, '2楼', '6栋2楼');
INSERT INTO `building` VALUES (1676476815827861590, '2-1', '6栋2楼2-1');
INSERT INTO `building` VALUES (1676476815827861591, '2-2', '6栋2楼2-2');
INSERT INTO `building` VALUES (1676476815827861592, '3楼', '6栋3楼');
INSERT INTO `building` VALUES (1676476815827861593, '3-1', '6栋3楼3-1');
INSERT INTO `building` VALUES (1676476815827861594, '3-2', '6栋3楼3-2');
INSERT INTO `building` VALUES (1676476815827861595, '4楼', '6栋4楼');
INSERT INTO `building` VALUES (1676476815827861596, '4-1', '6栋4楼4-1');
INSERT INTO `building` VALUES (1676476815827861597, '4-2', '6栋4楼4-2');
INSERT INTO `building` VALUES (1676476815827861598, '5楼', '6栋5楼');
INSERT INTO `building` VALUES (1676476815827861599, '5-1', '6栋5楼5-1');
INSERT INTO `building` VALUES (1676476815827861601, '4栋', '4栋');
INSERT INTO `building` VALUES (1676476815827861602, '2楼', '4栋2楼');
INSERT INTO `building` VALUES (1676476815827861603, '2-1', '4栋2楼2-1');
INSERT INTO `building` VALUES (1676476815827861604, '2-2', '4栋2楼2-2');
INSERT INTO `building` VALUES (1676476815827861605, '3楼', '4栋3楼');
INSERT INTO `building` VALUES (1676476815827861606, '3-1', '4栋3楼3-1');
INSERT INTO `building` VALUES (1676476815827861607, '3-2', '4栋3楼3-2');
INSERT INTO `building` VALUES (1676476815827861608, '4楼', '4栋4楼');
INSERT INTO `building` VALUES (1676476815827861609, '4-1', '4栋4楼4-1');
INSERT INTO `building` VALUES (1676476815827861610, '4-2', '4栋4楼4-2');
INSERT INTO `building` VALUES (1679003988682944513, '1-楼层', '1-楼层');
INSERT INTO `building` VALUES (1680857111452553218, '1栋', '1栋');
INSERT INTO `building` VALUES (1680857111456747522, '2楼', '1栋2楼');
INSERT INTO `building` VALUES (1680857111456747523, '2-1', '1栋2楼2-1');
INSERT INTO `building` VALUES (1680857111456747524, '2-2', '1栋2楼2-2');
INSERT INTO `building` VALUES (1680857111456747525, '2-3', '1栋2楼2-3');
INSERT INTO `building` VALUES (1680857111456747526, '2-4', '1栋2楼2-4');
INSERT INTO `building` VALUES (1680857111456747527, '2-5', '1栋2楼2-5');
INSERT INTO `building` VALUES (1680857111456747528, '2-6', '1栋2楼2-6');
INSERT INTO `building` VALUES (1680857111456747529, '2-7', '1栋2楼2-7');
INSERT INTO `building` VALUES (1680857111456747530, '2-8', '1栋2楼2-8');
INSERT INTO `building` VALUES (1680857111456747531, '2-9', '1栋2楼2-9');
INSERT INTO `building` VALUES (1680857111456747532, '2-10', '1栋2楼2-10');
INSERT INTO `building` VALUES (1680857111456747533, '2栋', '2栋');
INSERT INTO `building` VALUES (1680857111456747534, '1楼', '2栋1楼');
INSERT INTO `building` VALUES (1680857111456747535, '1-1', '2栋1楼1-1');
INSERT INTO `building` VALUES (1680857111456747536, '1-2', '2栋1楼1-2');
INSERT INTO `building` VALUES (1680857111456747537, '1-3', '2栋1楼1-3');
INSERT INTO `building` VALUES (1680857111456747538, '1-4', '2栋1楼1-4');
INSERT INTO `building` VALUES (1680857111456747539, '3栋', '3栋');
INSERT INTO `building` VALUES (1680857111456747540, '1楼', '3栋1楼');
INSERT INTO `building` VALUES (1680857111456747541, '1-1', '3栋1楼1-1');
INSERT INTO `building` VALUES (1680857111456747542, '1-2', '3栋1楼1-2');
INSERT INTO `building` VALUES (1680857111456747543, '1-3', '3栋1楼1-3');
INSERT INTO `building` VALUES (1680880049577328642, '物业中心', '物业中心');
INSERT INTO `building` VALUES (1680880049615077378, '1楼', '物业中心1楼');
INSERT INTO `building` VALUES (1680880049623465985, '1-1', '物业中心1楼1-1');
INSERT INTO `building` VALUES (1680880049623465986, '1-2', '物业中心1楼1-2');
INSERT INTO `building` VALUES (1680880049623465987, '2楼', '物业中心2楼');
INSERT INTO `building` VALUES (1680880049623465988, '2-1', '物业中心2楼2-1');
INSERT INTO `building` VALUES (1680880049623465989, '2-2', '物业中心2楼2-2');
INSERT INTO `building` VALUES (1680880049623465990, '西区商铺', '西区商铺');
INSERT INTO `building` VALUES (1680880049627660289, '1楼', '西区商铺1楼');
INSERT INTO `building` VALUES (1680880049627660290, '1-1', '西区商铺1楼1-1');
INSERT INTO `building` VALUES (1680880049627660291, '1-2', '西区商铺1楼1-2');
INSERT INTO `building` VALUES (1680880049627660292, '2楼', '西区商铺2楼');
INSERT INTO `building` VALUES (1680880049627660293, '2-1', '西区商铺2楼2-1');
INSERT INTO `building` VALUES (1680880049627660294, '2-2', '西区商铺2楼2-2');
INSERT INTO `building` VALUES (1680880049627660295, '东区商铺', '东区商铺');
INSERT INTO `building` VALUES (1680880049644437506, '1楼', '东区商铺1楼');
INSERT INTO `building` VALUES (1680880049644437507, '1-1', '东区商铺1楼1-1');
INSERT INTO `building` VALUES (1680880049644437508, '1-2', '东区商铺1楼1-2');
INSERT INTO `building` VALUES (1680880049644437509, '2楼', '东区商铺2楼');
INSERT INTO `building` VALUES (1680880049644437510, '2-2', '东区商铺2楼2-2');
INSERT INTO `building` VALUES (1680880049644437511, '2-2', '东区商铺2楼2-2');
INSERT INTO `building` VALUES (1680880049644437512, 'B区6栋', 'B区6栋');
INSERT INTO `building` VALUES (1680880049644437513, 'B区1栋', 'B区1栋');
INSERT INTO `building` VALUES (1680880049657020417, '22楼', 'B区1栋22楼');
INSERT INTO `building` VALUES (1680880049657020418, '22-1', 'B区1栋22楼22-1');
INSERT INTO `building` VALUES (1680880049657020419, '22-2', 'B区1栋22楼22-2');
INSERT INTO `building` VALUES (1680880049657020420, '22-3', 'B区1栋22楼22-3');
INSERT INTO `building` VALUES (1680880049657020421, '22-4', 'B区1栋22楼22-4');
INSERT INTO `building` VALUES (1680880049657020422, '22-5', 'B区1栋22楼22-5');
INSERT INTO `building` VALUES (1680880049657020423, '22-6', 'B区1栋22楼22-6');
INSERT INTO `building` VALUES (1680880049657020424, '23楼', 'B区1栋23楼');
INSERT INTO `building` VALUES (1680880049657020425, '23-1', 'B区1栋23楼23-1');
INSERT INTO `building` VALUES (1680880049657020426, '23-2', 'B区1栋23楼23-2');
INSERT INTO `building` VALUES (1680880049657020427, '23-3', 'B区1栋23楼23-3');
INSERT INTO `building` VALUES (1680880049657020428, '23-4', 'B区1栋23楼23-4');
INSERT INTO `building` VALUES (1680880049657020429, '23-5', 'B区1栋23楼23-5');
INSERT INTO `building` VALUES (1680880049661214722, '23-6', 'B区1栋23楼23-6');
INSERT INTO `building` VALUES (1680880049661214723, '24楼', 'B区1栋24楼');
INSERT INTO `building` VALUES (1680880049661214724, '24-1', 'B区1栋24楼24-1');
INSERT INTO `building` VALUES (1680880049661214725, '24-2', 'B区1栋24楼24-2');
INSERT INTO `building` VALUES (1680880049661214726, '24-3', 'B区1栋24楼24-3');
INSERT INTO `building` VALUES (1680880049661214727, '24-4', 'B区1栋24楼24-4');
INSERT INTO `building` VALUES (1680880049661214728, '24-5', 'B区1栋24楼24-5');
INSERT INTO `building` VALUES (1680880049661214729, '24-6', 'B区1栋24楼24-6');
INSERT INTO `building` VALUES (1680880049661214730, '25楼', 'B区1栋25楼');
INSERT INTO `building` VALUES (1680880049661214731, '25-1', 'B区1栋25楼25-1');
INSERT INTO `building` VALUES (1680880049661214732, '25-2', 'B区1栋25楼25-2');
INSERT INTO `building` VALUES (1680880049661214733, '25-3', 'B区1栋25楼25-3');
INSERT INTO `building` VALUES (1680880049661214734, '25-4', 'B区1栋25楼25-4');
INSERT INTO `building` VALUES (1680880049661214735, '25-5', 'B区1栋25楼25-5');
INSERT INTO `building` VALUES (1680880049661214736, '25-6', 'B区1栋25楼25-6');
INSERT INTO `building` VALUES (1680880049661214737, '26楼', 'B区1栋26楼');
INSERT INTO `building` VALUES (1680880049661214738, '26-1', 'B区1栋26楼26-1');
INSERT INTO `building` VALUES (1680880049661214739, '26-2', 'B区1栋26楼26-2');
INSERT INTO `building` VALUES (1680880049669603330, '26-3', 'B区1栋26楼26-3');
INSERT INTO `building` VALUES (1680880049669603331, '26-4', 'B区1栋26楼26-4');
INSERT INTO `building` VALUES (1680880049669603332, '26-5', 'B区1栋26楼26-5');
INSERT INTO `building` VALUES (1680880049669603333, '26-6', 'B区1栋26楼26-6');
INSERT INTO `building` VALUES (1680880049669603334, '27楼', 'B区1栋27楼');
INSERT INTO `building` VALUES (1680880049669603335, '27-1', 'B区1栋27楼27-1');
INSERT INTO `building` VALUES (1680880049669603336, '27-2', 'B区1栋27楼27-2');
INSERT INTO `building` VALUES (1680880049669603337, '27-3', 'B区1栋27楼27-3');
INSERT INTO `building` VALUES (1680880049669603338, '27-4', 'B区1栋27楼27-4');
INSERT INTO `building` VALUES (1680880049669603339, '27-5', 'B区1栋27楼27-5');
INSERT INTO `building` VALUES (1680880049669603340, '27-6', 'B区1栋27楼27-6');
INSERT INTO `building` VALUES (1680880049669603341, '28楼', 'B区1栋28楼');
INSERT INTO `building` VALUES (1680880049669603342, '28-1', 'B区1栋28楼28-1');
INSERT INTO `building` VALUES (1680880049669603343, '28-2', 'B区1栋28楼28-2');
INSERT INTO `building` VALUES (1680880049669603344, '28-3', 'B区1栋28楼28-3');
INSERT INTO `building` VALUES (1680880049673797633, '28-4', 'B区1栋28楼28-4');
INSERT INTO `building` VALUES (1680880049673797634, '28-5', 'B区1栋28楼28-5');
INSERT INTO `building` VALUES (1680880049673797635, '28-6', 'B区1栋28楼28-6');
INSERT INTO `building` VALUES (1680880049673797636, '29楼', 'B区1栋29楼');
INSERT INTO `building` VALUES (1680880049673797637, '29-1', 'B区1栋29楼29-1');
INSERT INTO `building` VALUES (1680880049673797638, '29-2', 'B区1栋29楼29-2');
INSERT INTO `building` VALUES (1680880049673797639, '29-3', 'B区1栋29楼29-3');
INSERT INTO `building` VALUES (1680880049673797640, '29-4', 'B区1栋29楼29-4');
INSERT INTO `building` VALUES (1680880049673797641, '29-5', 'B区1栋29楼29-5');
INSERT INTO `building` VALUES (1680880049673797642, '29-6', 'B区1栋29楼29-6');
INSERT INTO `building` VALUES (1680880049673797643, '30楼', 'B区1栋30楼');
INSERT INTO `building` VALUES (1680880049673797644, '30-1', 'B区1栋30楼30-1');
INSERT INTO `building` VALUES (1680880049673797645, '30-2', 'B区1栋30楼30-2');
INSERT INTO `building` VALUES (1680880049673797646, '30-3', 'B区1栋30楼30-3');
INSERT INTO `building` VALUES (1680880049673797647, '30-4', 'B区1栋30楼30-4');
INSERT INTO `building` VALUES (1680880049673797648, '30-5', 'B区1栋30楼30-5');
INSERT INTO `building` VALUES (1680880049673797649, '30-6', 'B区1栋30楼30-6');
INSERT INTO `building` VALUES (1680880049673797650, '10楼', 'B区1栋10楼');
INSERT INTO `building` VALUES (1680880049673797651, '10-1', 'B区1栋10楼10-1');
INSERT INTO `building` VALUES (1680880049673797652, '10-2', 'B区1栋10楼10-2');
INSERT INTO `building` VALUES (1680880049673797653, '10-3', 'B区1栋10楼10-3');
INSERT INTO `building` VALUES (1680880049673797654, '10-4', 'B区1栋10楼10-4');
INSERT INTO `building` VALUES (1680880049673797655, '10-5', 'B区1栋10楼10-5');
INSERT INTO `building` VALUES (1680880049673797656, '10-6', 'B区1栋10楼10-6');
INSERT INTO `building` VALUES (1680880049673797657, '11楼', 'B区1栋11楼');
INSERT INTO `building` VALUES (1680880049673797658, '11-1', 'B区1栋11楼11-1');
INSERT INTO `building` VALUES (1680880049673797659, '11-2', 'B区1栋11楼11-2');
INSERT INTO `building` VALUES (1680880049673797660, '11-3', 'B区1栋11楼11-3');
INSERT INTO `building` VALUES (1680880049673797661, '11-4', 'B区1栋11楼11-4');
INSERT INTO `building` VALUES (1680880049673797662, '11-5', 'B区1栋11楼11-5');
INSERT INTO `building` VALUES (1680880049673797663, '11-6', 'B区1栋11楼11-6');
INSERT INTO `building` VALUES (1680880049673797664, '12楼', 'B区1栋12楼');
INSERT INTO `building` VALUES (1680880049673797665, '12-1', 'B区1栋12楼12-1');
INSERT INTO `building` VALUES (1680880049673797666, '12-2', 'B区1栋12楼12-2');
INSERT INTO `building` VALUES (1680880049673797667, '12-3', 'B区1栋12楼12-3');
INSERT INTO `building` VALUES (1680880049673797668, '12-4', 'B区1栋12楼12-4');
INSERT INTO `building` VALUES (1680880049673797669, '12-5', 'B区1栋12楼12-5');
INSERT INTO `building` VALUES (1680880049673797670, '12-6', 'B区1栋12楼12-6');
INSERT INTO `building` VALUES (1680880049673797671, '13楼', 'B区1栋13楼');
INSERT INTO `building` VALUES (1680880049673797672, '13-1', 'B区1栋13楼13-1');
INSERT INTO `building` VALUES (1680880049673797673, '13-2', 'B区1栋13楼13-2');
INSERT INTO `building` VALUES (1680880049673797674, '13-3', 'B区1栋13楼13-3');
INSERT INTO `building` VALUES (1680880049673797675, '13-4', 'B区1栋13楼13-4');
INSERT INTO `building` VALUES (1680880049673797676, '13-5', 'B区1栋13楼13-5');
INSERT INTO `building` VALUES (1680880049673797677, '13-6', 'B区1栋13楼13-6');
INSERT INTO `building` VALUES (1680880049673797678, '14楼', 'B区1栋14楼');
INSERT INTO `building` VALUES (1680880049673797679, '14-1', 'B区1栋14楼14-1');
INSERT INTO `building` VALUES (1680880049673797680, '14-2', 'B区1栋14楼14-2');
INSERT INTO `building` VALUES (1680880049673797681, '14-3', 'B区1栋14楼14-3');
INSERT INTO `building` VALUES (1680880049673797682, '14-4', 'B区1栋14楼14-4');
INSERT INTO `building` VALUES (1680880049673797683, '14-5', 'B区1栋14楼14-5');
INSERT INTO `building` VALUES (1680880049673797684, '14-6', 'B区1栋14楼14-6');
INSERT INTO `building` VALUES (1680880049673797685, '15楼', 'B区1栋15楼');
INSERT INTO `building` VALUES (1680880049673797686, '15-1', 'B区1栋15楼15-1');
INSERT INTO `building` VALUES (1680880049673797687, '15-2', 'B区1栋15楼15-2');
INSERT INTO `building` VALUES (1680880049673797688, '15-3', 'B区1栋15楼15-3');
INSERT INTO `building` VALUES (1680880049673797689, '15-4', 'B区1栋15楼15-4');
INSERT INTO `building` VALUES (1680880049673797690, '15-5', 'B区1栋15楼15-5');
INSERT INTO `building` VALUES (1680880049673797691, '15-6', 'B区1栋15楼15-6');
INSERT INTO `building` VALUES (1680880049677991938, '16楼', 'B区1栋16楼');
INSERT INTO `building` VALUES (1680880049677991939, '16-1', 'B区1栋16楼16-1');
INSERT INTO `building` VALUES (1680880049677991940, '16-2', 'B区1栋16楼16-2');
INSERT INTO `building` VALUES (1680880049677991941, '16-3', 'B区1栋16楼16-3');
INSERT INTO `building` VALUES (1680880049677991942, '16-4', 'B区1栋16楼16-4');
INSERT INTO `building` VALUES (1680880049677991943, '16-6', 'B区1栋16楼16-6');
INSERT INTO `building` VALUES (1680880049677991944, '16-5', 'B区1栋16楼16-5');
INSERT INTO `building` VALUES (1680880049677991945, '17楼', 'B区1栋17楼');
INSERT INTO `building` VALUES (1680880049677991946, '17-1', 'B区1栋17楼17-1');
INSERT INTO `building` VALUES (1680880049677991947, '17-2', 'B区1栋17楼17-2');
INSERT INTO `building` VALUES (1680880049677991948, '17-3', 'B区1栋17楼17-3');
INSERT INTO `building` VALUES (1680880049677991949, '17-4', 'B区1栋17楼17-4');
INSERT INTO `building` VALUES (1680880049677991950, '17-5', 'B区1栋17楼17-5');
INSERT INTO `building` VALUES (1680880049677991951, '17-6', 'B区1栋17楼17-6');
INSERT INTO `building` VALUES (1680880049682186241, '18楼', 'B区1栋18楼');
INSERT INTO `building` VALUES (1680880049682186242, '18-1', 'B区1栋18楼18-1');
INSERT INTO `building` VALUES (1680880049682186243, '18-2', 'B区1栋18楼18-2');
INSERT INTO `building` VALUES (1680880049682186244, '18-3', 'B区1栋18楼18-3');
INSERT INTO `building` VALUES (1680880049682186245, '18-4', 'B区1栋18楼18-4');
INSERT INTO `building` VALUES (1680880049682186246, '18-5', 'B区1栋18楼18-5');
INSERT INTO `building` VALUES (1680880049682186247, '18-6', 'B区1栋18楼18-6');
INSERT INTO `building` VALUES (1680880049682186248, '19楼', 'B区1栋19楼');
INSERT INTO `building` VALUES (1680880049682186249, '19-1', 'B区1栋19楼19-1');
INSERT INTO `building` VALUES (1680880049682186250, '19-2', 'B区1栋19楼19-2');
INSERT INTO `building` VALUES (1680880049682186251, '19-3', 'B区1栋19楼19-3');
INSERT INTO `building` VALUES (1680880049682186252, '19-4', 'B区1栋19楼19-4');
INSERT INTO `building` VALUES (1680880049682186253, '19-5', 'B区1栋19楼19-5');
INSERT INTO `building` VALUES (1680880049682186254, '19-6', 'B区1栋19楼19-6');
INSERT INTO `building` VALUES (1680880049682186255, '1楼', 'B区1栋1楼');
INSERT INTO `building` VALUES (1680880049682186256, '1-1', 'B区1栋1楼1-1');
INSERT INTO `building` VALUES (1680880049682186257, '1-2', 'B区1栋1楼1-2');
INSERT INTO `building` VALUES (1680880049682186258, '1-3', 'B区1栋1楼1-3');
INSERT INTO `building` VALUES (1680880049686380546, '1-4', 'B区1栋1楼1-4');
INSERT INTO `building` VALUES (1680880049686380547, '1-5', 'B区1栋1楼1-5');
INSERT INTO `building` VALUES (1680880049686380548, '1-6', 'B区1栋1楼1-6');
INSERT INTO `building` VALUES (1680880049686380549, '2楼', 'B区1栋2楼');
INSERT INTO `building` VALUES (1680880049686380550, '2-1', 'B区1栋2楼2-1');
INSERT INTO `building` VALUES (1680880049686380551, '2-2', 'B区1栋2楼2-2');
INSERT INTO `building` VALUES (1680880049686380552, '2-3', 'B区1栋2楼2-3');
INSERT INTO `building` VALUES (1680880049686380553, '2-4', 'B区1栋2楼2-4');
INSERT INTO `building` VALUES (1680880049686380554, '2-5', 'B区1栋2楼2-5');
INSERT INTO `building` VALUES (1680880049686380555, '2-6', 'B区1栋2楼2-6');
INSERT INTO `building` VALUES (1680880049686380556, '3楼', 'B区1栋3楼');
INSERT INTO `building` VALUES (1680880049686380557, '3-1', 'B区1栋3楼3-1');
INSERT INTO `building` VALUES (1680880049686380558, '3-2', 'B区1栋3楼3-2');
INSERT INTO `building` VALUES (1680880049686380559, '3-3', 'B区1栋3楼3-3');
INSERT INTO `building` VALUES (1680880049686380560, '3-4', 'B区1栋3楼3-4');
INSERT INTO `building` VALUES (1680880049686380561, '3-5', 'B区1栋3楼3-5');
INSERT INTO `building` VALUES (1680880049686380562, '3-6', 'B区1栋3楼3-6');
INSERT INTO `building` VALUES (1680880049686380563, '4楼', 'B区1栋4楼');
INSERT INTO `building` VALUES (1680880049686380564, '4-1', 'B区1栋4楼4-1');
INSERT INTO `building` VALUES (1680880049686380565, '4-2', 'B区1栋4楼4-2');
INSERT INTO `building` VALUES (1680880049686380566, '4-3', 'B区1栋4楼4-3');
INSERT INTO `building` VALUES (1680880049686380567, '4-4', 'B区1栋4楼4-4');
INSERT INTO `building` VALUES (1680880049686380568, '4-5', 'B区1栋4楼4-5');
INSERT INTO `building` VALUES (1680880049686380569, '4-6', 'B区1栋4楼4-6');
INSERT INTO `building` VALUES (1680880049686380570, '5楼', 'B区1栋5楼');
INSERT INTO `building` VALUES (1680880049686380571, '5-1', 'B区1栋5楼5-1');
INSERT INTO `building` VALUES (1680880049686380572, '5-2', 'B区1栋5楼5-2');
INSERT INTO `building` VALUES (1680880049686380573, '5-3', 'B区1栋5楼5-3');
INSERT INTO `building` VALUES (1680880049686380574, '5-4', 'B区1栋5楼5-4');
INSERT INTO `building` VALUES (1680880049686380575, '5-5', 'B区1栋5楼5-5');
INSERT INTO `building` VALUES (1680880049686380576, '5-6', 'B区1栋5楼5-6');
INSERT INTO `building` VALUES (1680880049686380577, '6楼', 'B区1栋6楼');
INSERT INTO `building` VALUES (1680880049686380578, '6-1', 'B区1栋6楼6-1');
INSERT INTO `building` VALUES (1680880049686380579, '6-2', 'B区1栋6楼6-2');
INSERT INTO `building` VALUES (1680880049686380580, '6-3', 'B区1栋6楼6-3');
INSERT INTO `building` VALUES (1680880049686380581, '6-4', 'B区1栋6楼6-4');
INSERT INTO `building` VALUES (1680880049686380582, '6-5', 'B区1栋6楼6-5');
INSERT INTO `building` VALUES (1680880049686380583, '6-6', 'B区1栋6楼6-6');
INSERT INTO `building` VALUES (1680880049686380584, '7楼', 'B区1栋7楼');
INSERT INTO `building` VALUES (1680880049686380585, '7-1', 'B区1栋7楼7-1');
INSERT INTO `building` VALUES (1680880049686380586, '7-2', 'B区1栋7楼7-2');
INSERT INTO `building` VALUES (1680880049686380587, '7-3', 'B区1栋7楼7-3');
INSERT INTO `building` VALUES (1680880049686380588, '7-4', 'B区1栋7楼7-4');
INSERT INTO `building` VALUES (1680880049686380589, '7-5', 'B区1栋7楼7-5');
INSERT INTO `building` VALUES (1680880049686380590, '7-6', 'B区1栋7楼7-6');
INSERT INTO `building` VALUES (1680880049686380591, '8楼', 'B区1栋8楼');
INSERT INTO `building` VALUES (1680880049686380592, '8-1', 'B区1栋8楼8-1');
INSERT INTO `building` VALUES (1680880049686380593, '8-2', 'B区1栋8楼8-2');
INSERT INTO `building` VALUES (1680880049686380594, '8-3', 'B区1栋8楼8-3');
INSERT INTO `building` VALUES (1680880049686380595, '8-4', 'B区1栋8楼8-4');
INSERT INTO `building` VALUES (1680880049686380596, '8-5', 'B区1栋8楼8-5');
INSERT INTO `building` VALUES (1680880049686380597, '8-6', 'B区1栋8楼8-6');
INSERT INTO `building` VALUES (1680880049686380598, '9楼', 'B区1栋9楼');
INSERT INTO `building` VALUES (1680880049694769154, '9-1', 'B区1栋9楼9-1');
INSERT INTO `building` VALUES (1680880049698963458, '9-2', 'B区1栋9楼9-2');
INSERT INTO `building` VALUES (1680880049698963459, '9-3', 'B区1栋9楼9-3');
INSERT INTO `building` VALUES (1680880049698963460, '9-4', 'B区1栋9楼9-4');
INSERT INTO `building` VALUES (1680880049698963461, '9-5', 'B区1栋9楼9-5');
INSERT INTO `building` VALUES (1680880049698963462, '9-6', 'B区1栋9楼9-6');
INSERT INTO `building` VALUES (1680880049698963463, '20楼', 'B区1栋20楼');
INSERT INTO `building` VALUES (1680880049698963464, '20-1', 'B区1栋20楼20-1');
INSERT INTO `building` VALUES (1680880049698963465, '20-2', 'B区1栋20楼20-2');
INSERT INTO `building` VALUES (1680880049698963466, '20-3', 'B区1栋20楼20-3');
INSERT INTO `building` VALUES (1680880049698963467, '20-4', 'B区1栋20楼20-4');
INSERT INTO `building` VALUES (1680880049698963468, '20-5', 'B区1栋20楼20-5');
INSERT INTO `building` VALUES (1680880049698963469, '20-6', 'B区1栋20楼20-6');
INSERT INTO `building` VALUES (1680880049698963470, '21楼', 'B区1栋21楼');
INSERT INTO `building` VALUES (1680880049698963471, '21-1', 'B区1栋21楼21-1');
INSERT INTO `building` VALUES (1680880049698963472, '21-2', 'B区1栋21楼21-2');
INSERT INTO `building` VALUES (1680880049698963473, '21-3', 'B区1栋21楼21-3');
INSERT INTO `building` VALUES (1680880049698963474, '21-4', 'B区1栋21楼21-4');
INSERT INTO `building` VALUES (1680880049698963475, '21-5', 'B区1栋21楼21-5');
INSERT INTO `building` VALUES (1680880049698963476, '21-6', 'B区1栋21楼21-6');
INSERT INTO `building` VALUES (1680880049698963477, 'A区1栋', 'A区1栋');
INSERT INTO `building` VALUES (1680880049698963478, '11楼', 'A区1栋11楼');
INSERT INTO `building` VALUES (1680880049698963479, '11-1', 'A区1栋11楼11-1');
INSERT INTO `building` VALUES (1680880049698963480, '11-2', 'A区1栋11楼11-2');
INSERT INTO `building` VALUES (1680880049698963481, '11-3', 'A区1栋11楼11-3');
INSERT INTO `building` VALUES (1680880049698963482, '11-4', 'A区1栋11楼11-4');
INSERT INTO `building` VALUES (1680880049698963483, '1楼', 'A区1栋1楼');
INSERT INTO `building` VALUES (1680880049698963484, '1-1', 'A区1栋1楼1-1');
INSERT INTO `building` VALUES (1680880049698963485, '1-2', 'A区1栋1楼1-2');
INSERT INTO `building` VALUES (1680880049698963486, '1-3', 'A区1栋1楼1-3');
INSERT INTO `building` VALUES (1680880049698963487, '1-4', 'A区1栋1楼1-4');
INSERT INTO `building` VALUES (1680880049698963488, '2楼', 'A区1栋2楼');
INSERT INTO `building` VALUES (1680880049698963489, '2-1', 'A区1栋2楼2-1');
INSERT INTO `building` VALUES (1680880049707352065, '2-2', 'A区1栋2楼2-2');
INSERT INTO `building` VALUES (1680880049707352066, '2-3', 'A区1栋2楼2-3');
INSERT INTO `building` VALUES (1680880049707352067, '2-4', 'A区1栋2楼2-4');
INSERT INTO `building` VALUES (1680880049707352068, '3楼', 'A区1栋3楼');
INSERT INTO `building` VALUES (1680880049707352069, '3-1', 'A区1栋3楼3-1');
INSERT INTO `building` VALUES (1680880049707352070, '3-2', 'A区1栋3楼3-2');
INSERT INTO `building` VALUES (1680880049707352071, '3-3', 'A区1栋3楼3-3');
INSERT INTO `building` VALUES (1680880049707352072, '3-4', 'A区1栋3楼3-4');
INSERT INTO `building` VALUES (1680880049707352073, '4楼', 'A区1栋4楼');
INSERT INTO `building` VALUES (1680880049707352074, '4-1', 'A区1栋4楼4-1');
INSERT INTO `building` VALUES (1680880049707352075, '4-2', 'A区1栋4楼4-2');
INSERT INTO `building` VALUES (1680880049707352076, '4-3', 'A区1栋4楼4-3');
INSERT INTO `building` VALUES (1680880049707352077, '4-4', 'A区1栋4楼4-4');
INSERT INTO `building` VALUES (1680880049707352078, '5楼', 'A区1栋5楼');
INSERT INTO `building` VALUES (1680880049707352079, '5-1', 'A区1栋5楼5-1');
INSERT INTO `building` VALUES (1680880049707352080, '5-2', 'A区1栋5楼5-2');
INSERT INTO `building` VALUES (1680880049707352081, '5-3', 'A区1栋5楼5-3');
INSERT INTO `building` VALUES (1680880049707352082, '5-4', 'A区1栋5楼5-4');
INSERT INTO `building` VALUES (1680880049707352083, '6楼', 'A区1栋6楼');
INSERT INTO `building` VALUES (1680880049711546370, '6-1', 'A区1栋6楼6-1');
INSERT INTO `building` VALUES (1680880049711546371, '6-2', 'A区1栋6楼6-2');
INSERT INTO `building` VALUES (1680880049711546372, '6-3', 'A区1栋6楼6-3');
INSERT INTO `building` VALUES (1680880049711546373, '6-4', 'A区1栋6楼6-4');
INSERT INTO `building` VALUES (1680880049711546374, '7楼', 'A区1栋7楼');
INSERT INTO `building` VALUES (1680880049711546375, '7-1', 'A区1栋7楼7-1');
INSERT INTO `building` VALUES (1680880049711546376, '7-2', 'A区1栋7楼7-2');
INSERT INTO `building` VALUES (1680880049711546377, '7-3', 'A区1栋7楼7-3');
INSERT INTO `building` VALUES (1680880049711546378, '7-4', 'A区1栋7楼7-4');
INSERT INTO `building` VALUES (1680880049711546379, '8楼', 'A区1栋8楼');
INSERT INTO `building` VALUES (1680880049711546380, '8-1', 'A区1栋8楼8-1');
INSERT INTO `building` VALUES (1680880049711546381, '8-2', 'A区1栋8楼8-2');
INSERT INTO `building` VALUES (1680880049711546382, '8-3', 'A区1栋8楼8-3');
INSERT INTO `building` VALUES (1680880049711546383, '8-4', 'A区1栋8楼8-4');
INSERT INTO `building` VALUES (1680880049711546384, '9楼', 'A区1栋9楼');
INSERT INTO `building` VALUES (1680880049711546385, '9-1', 'A区1栋9楼9-1');
INSERT INTO `building` VALUES (1680880049711546386, '9-2', 'A区1栋9楼9-2');
INSERT INTO `building` VALUES (1680880049711546387, '9-3', 'A区1栋9楼9-3');
INSERT INTO `building` VALUES (1680880049711546388, '9-4', 'A区1栋9楼9-4');
INSERT INTO `building` VALUES (1680880049711546389, '10楼', 'A区1栋10楼');
INSERT INTO `building` VALUES (1680880049711546390, '10-1', 'A区1栋10楼10-1');
INSERT INTO `building` VALUES (1680880049711546391, '10-2', 'A区1栋10楼10-2');
INSERT INTO `building` VALUES (1680880049711546392, '10-3', 'A区1栋10楼10-3');
INSERT INTO `building` VALUES (1680880049711546393, '10-4', 'A区1栋10楼10-4');
INSERT INTO `building` VALUES (1680880049711546394, 'A区2栋', 'A区2栋');
INSERT INTO `building` VALUES (1680880049711546395, '11楼', 'A区2栋11楼');
INSERT INTO `building` VALUES (1680880049711546396, '11-1', 'A区2栋11楼11-1');
INSERT INTO `building` VALUES (1680880049724129281, '11-2', 'A区2栋11楼11-2');
INSERT INTO `building` VALUES (1680880049724129282, '1楼', 'A区2栋1楼');
INSERT INTO `building` VALUES (1680880049724129283, '1-1', 'A区2栋1楼1-1');
INSERT INTO `building` VALUES (1680880049724129284, '1-2', 'A区2栋1楼1-2');
INSERT INTO `building` VALUES (1680880049724129285, '2楼', 'A区2栋2楼');
INSERT INTO `building` VALUES (1680880049724129286, '2-1', 'A区2栋2楼2-1');
INSERT INTO `building` VALUES (1680880049724129287, '2-2', 'A区2栋2楼2-2');
INSERT INTO `building` VALUES (1680880049724129288, '3楼', 'A区2栋3楼');
INSERT INTO `building` VALUES (1680880049724129289, '3-1', 'A区2栋3楼3-1');
INSERT INTO `building` VALUES (1680880049724129290, '3-2', 'A区2栋3楼3-2');
INSERT INTO `building` VALUES (1680880049724129291, '4楼', 'A区2栋4楼');
INSERT INTO `building` VALUES (1680880049724129292, '4-1', 'A区2栋4楼4-1');
INSERT INTO `building` VALUES (1680880049724129293, '4-2', 'A区2栋4楼4-2');
INSERT INTO `building` VALUES (1680880049724129294, '5楼', 'A区2栋5楼');
INSERT INTO `building` VALUES (1680880049724129295, '5-1', 'A区2栋5楼5-1');
INSERT INTO `building` VALUES (1680880049724129296, '5-2', 'A区2栋5楼5-2');
INSERT INTO `building` VALUES (1680880049724129297, '6楼', 'A区2栋6楼');
INSERT INTO `building` VALUES (1680880049724129298, '6-1', 'A区2栋6楼6-1');
INSERT INTO `building` VALUES (1680880049724129299, '6-2', 'A区2栋6楼6-2');
INSERT INTO `building` VALUES (1680880049724129300, '7楼', 'A区2栋7楼');
INSERT INTO `building` VALUES (1680880049724129301, '7-1', 'A区2栋7楼7-1');
INSERT INTO `building` VALUES (1680880049724129302, '7-2', 'A区2栋7楼7-2');
INSERT INTO `building` VALUES (1680880049728323585, '8楼', 'A区2栋8楼');
INSERT INTO `building` VALUES (1680880049728323586, '8-1', 'A区2栋8楼8-1');
INSERT INTO `building` VALUES (1680880049728323587, '8-2', 'A区2栋8楼8-2');
INSERT INTO `building` VALUES (1680880049728323588, '9楼', 'A区2栋9楼');
INSERT INTO `building` VALUES (1680880049728323589, '9-1', 'A区2栋9楼9-1');
INSERT INTO `building` VALUES (1680880049728323590, '9-2', 'A区2栋9楼9-2');
INSERT INTO `building` VALUES (1680880049728323591, '10楼', 'A区2栋10楼');
INSERT INTO `building` VALUES (1680880049728323592, '10-1', 'A区2栋10楼10-1');
INSERT INTO `building` VALUES (1680880049728323593, '10-2', 'A区2栋10楼10-2');
INSERT INTO `building` VALUES (1680880049728323594, 'A区3栋', 'A区3栋');
INSERT INTO `building` VALUES (1680880049736712194, 'A区4栋', 'A区4栋');
INSERT INTO `building` VALUES (1680880049745100801, 'B区3栋', 'B区3栋');
INSERT INTO `building` VALUES (1680880049745100802, 'B区4栋', 'B区4栋');
INSERT INTO `building` VALUES (1680880049745100803, 'B区5栋', 'B区5栋');
INSERT INTO `building` VALUES (1680880049761878018, 'B区2栋', 'B区2栋');
INSERT INTO `building` VALUES (1680880049761878019, '22楼', 'B区2栋22楼');
INSERT INTO `building` VALUES (1680880049761878020, '22-1', 'B区2栋22楼22-1');
INSERT INTO `building` VALUES (1680880049761878021, '22-2', 'B区2栋22楼22-2');
INSERT INTO `building` VALUES (1680880049761878022, '22-3', 'B区2栋22楼22-3');
INSERT INTO `building` VALUES (1680880049761878023, '22-4', 'B区2栋22楼22-4');
INSERT INTO `building` VALUES (1680880049761878024, '23楼', 'B区2栋23楼');
INSERT INTO `building` VALUES (1680880049761878025, '23-1', 'B区2栋23楼23-1');
INSERT INTO `building` VALUES (1680880049761878026, '23-2', 'B区2栋23楼23-2');
INSERT INTO `building` VALUES (1680880049761878027, '23-3', 'B区2栋23楼23-3');
INSERT INTO `building` VALUES (1680880049761878028, '23-4', 'B区2栋23楼23-4');
INSERT INTO `building` VALUES (1680880049761878029, '24楼', 'B区2栋24楼');
INSERT INTO `building` VALUES (1680880049761878030, '24-1', 'B区2栋24楼24-1');
INSERT INTO `building` VALUES (1680880049761878031, '24-2', 'B区2栋24楼24-2');
INSERT INTO `building` VALUES (1680880049761878032, '24-3', 'B区2栋24楼24-3');
INSERT INTO `building` VALUES (1680880049761878033, '24-4', 'B区2栋24楼24-4');
INSERT INTO `building` VALUES (1680880049761878034, '25楼', 'B区2栋25楼');
INSERT INTO `building` VALUES (1680880049761878035, '25-1', 'B区2栋25楼25-1');
INSERT INTO `building` VALUES (1680880049774460929, '25-2', 'B区2栋25楼25-2');
INSERT INTO `building` VALUES (1680880049774460930, '25-3', 'B区2栋25楼25-3');
INSERT INTO `building` VALUES (1680880049774460931, '25-4', 'B区2栋25楼25-4');
INSERT INTO `building` VALUES (1680880049774460932, '26楼', 'B区2栋26楼');
INSERT INTO `building` VALUES (1680880049774460933, '26-1', 'B区2栋26楼26-1');
INSERT INTO `building` VALUES (1680880049774460934, '26-2', 'B区2栋26楼26-2');
INSERT INTO `building` VALUES (1680880049774460935, '26-3', 'B区2栋26楼26-3');
INSERT INTO `building` VALUES (1680880049774460936, '26-4', 'B区2栋26楼26-4');
INSERT INTO `building` VALUES (1680880049774460937, '27楼', 'B区2栋27楼');
INSERT INTO `building` VALUES (1680880049774460938, '27-1', 'B区2栋27楼27-1');
INSERT INTO `building` VALUES (1680880049774460939, '27-2', 'B区2栋27楼27-2');
INSERT INTO `building` VALUES (1680880049774460940, '27-3', 'B区2栋27楼27-3');
INSERT INTO `building` VALUES (1680880049774460941, '27-4', 'B区2栋27楼27-4');
INSERT INTO `building` VALUES (1680880049774460942, '28楼', 'B区2栋28楼');
INSERT INTO `building` VALUES (1680880049774460943, '28-1', 'B区2栋28楼28-1');
INSERT INTO `building` VALUES (1680880049774460944, '28-2', 'B区2栋28楼28-2');
INSERT INTO `building` VALUES (1680880049774460945, '28-3', 'B区2栋28楼28-3');
INSERT INTO `building` VALUES (1680880049774460946, '28-4', 'B区2栋28楼28-4');
INSERT INTO `building` VALUES (1680880049774460947, '29楼', 'B区2栋29楼');
INSERT INTO `building` VALUES (1680880049774460948, '29-1', 'B区2栋29楼29-1');
INSERT INTO `building` VALUES (1680880049774460949, '29-2', 'B区2栋29楼29-2');
INSERT INTO `building` VALUES (1680880049774460950, '29-3', 'B区2栋29楼29-3');
INSERT INTO `building` VALUES (1680880049774460951, '29-4', 'B区2栋29楼29-4');
INSERT INTO `building` VALUES (1680880049774460952, '30楼', 'B区2栋30楼');
INSERT INTO `building` VALUES (1680880049774460953, '30-1', 'B区2栋30楼30-1');
INSERT INTO `building` VALUES (1680880049774460954, '30-2', 'B区2栋30楼30-2');
INSERT INTO `building` VALUES (1680880049774460955, '30-3', 'B区2栋30楼30-3');
INSERT INTO `building` VALUES (1680880049774460956, '30-4', 'B区2栋30楼30-4');
INSERT INTO `building` VALUES (1680880049774460957, '10楼', 'B区2栋10楼');
INSERT INTO `building` VALUES (1680880049774460958, '10-1', 'B区2栋10楼10-1');
INSERT INTO `building` VALUES (1680880049774460959, '10-2', 'B区2栋10楼10-2');
INSERT INTO `building` VALUES (1680880049774460960, '10-3', 'B区2栋10楼10-3');
INSERT INTO `building` VALUES (1680880049774460961, '10-4', 'B区2栋10楼10-4');
INSERT INTO `building` VALUES (1680880049774460962, '11楼', 'B区2栋11楼');
INSERT INTO `building` VALUES (1680880049774460963, '11-1', 'B区2栋11楼11-1');
INSERT INTO `building` VALUES (1680880049774460964, '11-2', 'B区2栋11楼11-2');
INSERT INTO `building` VALUES (1680880049774460965, '11-3', 'B区2栋11楼11-3');
INSERT INTO `building` VALUES (1680880049774460966, '11-4', 'B区2栋11楼11-4');
INSERT INTO `building` VALUES (1680880049774460967, '12楼', 'B区2栋12楼');
INSERT INTO `building` VALUES (1680880049774460968, '12-1', 'B区2栋12楼12-1');
INSERT INTO `building` VALUES (1680880049774460969, '12-2', 'B区2栋12楼12-2');
INSERT INTO `building` VALUES (1680880049774460970, '12-3', 'B区2栋12楼12-3');
INSERT INTO `building` VALUES (1680880049774460971, '12-4', 'B区2栋12楼12-4');
INSERT INTO `building` VALUES (1680880049774460972, '13楼', 'B区2栋13楼');
INSERT INTO `building` VALUES (1680880049774460973, '13-1', 'B区2栋13楼13-1');
INSERT INTO `building` VALUES (1680880049774460974, '13-2', 'B区2栋13楼13-2');
INSERT INTO `building` VALUES (1680880049774460975, '13-4', 'B区2栋13楼13-4');
INSERT INTO `building` VALUES (1680880049774460976, '13-3', 'B区2栋13楼13-3');
INSERT INTO `building` VALUES (1680880049774460977, '14楼', 'B区2栋14楼');
INSERT INTO `building` VALUES (1680880049774460978, '14-1', 'B区2栋14楼14-1');
INSERT INTO `building` VALUES (1680880049774460979, '14-2', 'B区2栋14楼14-2');
INSERT INTO `building` VALUES (1680880049774460980, '14-3', 'B区2栋14楼14-3');
INSERT INTO `building` VALUES (1680880049774460981, '14-4', 'B区2栋14楼14-4');
INSERT INTO `building` VALUES (1680880049774460982, '15楼', 'B区2栋15楼');
INSERT INTO `building` VALUES (1680880049774460983, '15-1', 'B区2栋15楼15-1');
INSERT INTO `building` VALUES (1680880049774460984, '15-2', 'B区2栋15楼15-2');
INSERT INTO `building` VALUES (1680880049774460985, '15-4', 'B区2栋15楼15-4');
INSERT INTO `building` VALUES (1680880049774460986, '15-3', 'B区2栋15楼15-3');
INSERT INTO `building` VALUES (1680880049774460987, '16楼', 'B区2栋16楼');
INSERT INTO `building` VALUES (1680880049774460988, '16-1', 'B区2栋16楼16-1');
INSERT INTO `building` VALUES (1680880049774460989, '16-2', 'B区2栋16楼16-2');
INSERT INTO `building` VALUES (1680880049774460990, '16-3', 'B区2栋16楼16-3');
INSERT INTO `building` VALUES (1680880049774460991, '16-4', 'B区2栋16楼16-4');
INSERT INTO `building` VALUES (1680880049774460992, '17楼', 'B区2栋17楼');
INSERT INTO `building` VALUES (1680880049774460993, '17-1', 'B区2栋17楼17-1');
INSERT INTO `building` VALUES (1680880049774460994, '17-2', 'B区2栋17楼17-2');
INSERT INTO `building` VALUES (1680880049774460995, '17-3', 'B区2栋17楼17-3');
INSERT INTO `building` VALUES (1680880049774460996, '17-4', 'B区2栋17楼17-4');
INSERT INTO `building` VALUES (1680880049774460997, '18楼', 'B区2栋18楼');
INSERT INTO `building` VALUES (1680880049774460998, '18-1', 'B区2栋18楼18-1');
INSERT INTO `building` VALUES (1680880049774460999, '18-2', 'B区2栋18楼18-2');
INSERT INTO `building` VALUES (1680880049774461000, '18-3', 'B区2栋18楼18-3');
INSERT INTO `building` VALUES (1680880049774461001, '18-4', 'B区2栋18楼18-4');
INSERT INTO `building` VALUES (1680880049774461002, '19楼', 'B区2栋19楼');
INSERT INTO `building` VALUES (1680880049774461003, '19-1', 'B区2栋19楼19-1');
INSERT INTO `building` VALUES (1680880049774461004, '19-2', 'B区2栋19楼19-2');
INSERT INTO `building` VALUES (1680880049774461005, '19-3', 'B区2栋19楼19-3');
INSERT INTO `building` VALUES (1680880049774461006, '19-4', 'B区2栋19楼19-4');
INSERT INTO `building` VALUES (1680880049774461007, '1楼', 'B区2栋1楼');
INSERT INTO `building` VALUES (1680880049774461008, '1-1', 'B区2栋1楼1-1');
INSERT INTO `building` VALUES (1680880049774461009, '1-2', 'B区2栋1楼1-2');
INSERT INTO `building` VALUES (1680880049774461010, '1-3', 'B区2栋1楼1-3');
INSERT INTO `building` VALUES (1680880049774461011, '1-4', 'B区2栋1楼1-4');
INSERT INTO `building` VALUES (1680880049774461012, '2楼', 'B区2栋2楼');
INSERT INTO `building` VALUES (1680880049774461013, '2-1', 'B区2栋2楼2-1');
INSERT INTO `building` VALUES (1680880049774461014, '2-2', 'B区2栋2楼2-2');
INSERT INTO `building` VALUES (1680880049774461015, '2-3', 'B区2栋2楼2-3');
INSERT INTO `building` VALUES (1680880049774461016, '2-4', 'B区2栋2楼2-4');
INSERT INTO `building` VALUES (1680880049774461017, '3楼', 'B区2栋3楼');
INSERT INTO `building` VALUES (1680880049774461018, '3-1', 'B区2栋3楼3-1');
INSERT INTO `building` VALUES (1680880049774461019, '3-2', 'B区2栋3楼3-2');
INSERT INTO `building` VALUES (1680880049774461020, '3-3', 'B区2栋3楼3-3');
INSERT INTO `building` VALUES (1680880049774461021, '3-4', 'B区2栋3楼3-4');
INSERT INTO `building` VALUES (1680880049774461022, '4楼', 'B区2栋4楼');
INSERT INTO `building` VALUES (1680880049774461023, '4-1', 'B区2栋4楼4-1');
INSERT INTO `building` VALUES (1680880049774461024, '4-2', 'B区2栋4楼4-2');
INSERT INTO `building` VALUES (1680880049774461025, '4-3', 'B区2栋4楼4-3');
INSERT INTO `building` VALUES (1680880049774461026, '4-4', 'B区2栋4楼4-4');
INSERT INTO `building` VALUES (1680880049774461027, '5楼', 'B区2栋5楼');
INSERT INTO `building` VALUES (1680880049774461028, '5-1', 'B区2栋5楼5-1');
INSERT INTO `building` VALUES (1680880049774461029, '5-2', 'B区2栋5楼5-2');
INSERT INTO `building` VALUES (1680880049774461030, '5-3', 'B区2栋5楼5-3');
INSERT INTO `building` VALUES (1680880049774461031, '5-4', 'B区2栋5楼5-4');
INSERT INTO `building` VALUES (1680880049774461032, '6楼', 'B区2栋6楼');
INSERT INTO `building` VALUES (1680880049774461033, '6-1', 'B区2栋6楼6-1');
INSERT INTO `building` VALUES (1680880049774461034, '6-2', 'B区2栋6楼6-2');
INSERT INTO `building` VALUES (1680880049774461035, '6-3', 'B区2栋6楼6-3');
INSERT INTO `building` VALUES (1680880049774461036, '6-4', 'B区2栋6楼6-4');
INSERT INTO `building` VALUES (1680880049787043842, '7楼', 'B区2栋7楼');
INSERT INTO `building` VALUES (1680880049791238145, '7-1', 'B区2栋7楼7-1');
INSERT INTO `building` VALUES (1680880049791238146, '7-2', 'B区2栋7楼7-2');
INSERT INTO `building` VALUES (1680880049791238147, '7-3', 'B区2栋7楼7-3');
INSERT INTO `building` VALUES (1680880049791238148, '7-4', 'B区2栋7楼7-4');
INSERT INTO `building` VALUES (1680880049791238149, '8楼', 'B区2栋8楼');
INSERT INTO `building` VALUES (1680880049791238150, '8-1', 'B区2栋8楼8-1');
INSERT INTO `building` VALUES (1680880049791238151, '8-2', 'B区2栋8楼8-2');
INSERT INTO `building` VALUES (1680880049791238152, '8-3', 'B区2栋8楼8-3');
INSERT INTO `building` VALUES (1680880049791238153, '8-4', 'B区2栋8楼8-4');
INSERT INTO `building` VALUES (1680880049791238154, '9楼', 'B区2栋9楼');
INSERT INTO `building` VALUES (1680880049791238155, '9-1', 'B区2栋9楼9-1');
INSERT INTO `building` VALUES (1680880049791238156, '9-2', 'B区2栋9楼9-2');
INSERT INTO `building` VALUES (1680880049791238157, '9-3', 'B区2栋9楼9-3');
INSERT INTO `building` VALUES (1680880049791238158, '9-4', 'B区2栋9楼9-4');
INSERT INTO `building` VALUES (1680880049791238159, '20楼', 'B区2栋20楼');
INSERT INTO `building` VALUES (1680880049791238160, '20-1', 'B区2栋20楼20-1');
INSERT INTO `building` VALUES (1680880049791238161, '20-2', 'B区2栋20楼20-2');
INSERT INTO `building` VALUES (1680880049791238162, '20-3', 'B区2栋20楼20-3');
INSERT INTO `building` VALUES (1680880049791238163, '20-4', 'B区2栋20楼20-4');
INSERT INTO `building` VALUES (1680880049791238164, '21楼', 'B区2栋21楼');
INSERT INTO `building` VALUES (1680880049791238165, '21-1', 'B区2栋21楼21-1');
INSERT INTO `building` VALUES (1680880049791238166, '21-2', 'B区2栋21楼21-2');
INSERT INTO `building` VALUES (1680880049791238167, '21-3', 'B区2栋21楼21-3');
INSERT INTO `building` VALUES (1680880049791238168, '21-4', 'B区2栋21楼21-4');

SET FOREIGN_KEY_CHECKS = 1;

需要对name字段排序，正常操作
在这里插入图片描述
1后面是10不符合预期

修改后的SQL

SELECT
	*,
	NAME + 0 
FROM
	building 
ORDER BY
	NAME + 0, NAME

结果:
在这里插入图片描述

不吃糯玉米
关注
  • 0
    点赞
  • 踩
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
mysql从大到小排序_SQL（一）
weixin_34168834的博客
02-02 2308
SQL是结构化查询语言的缩写，用来访问和操作数据库系统。SQL语句既可以查询数据库中的数据，也可以添加、更新和删除数据库中的数据，还可以对数据库进行管理和维护操作。不同的数据库，都支持SQL。但，大部分数据库都在标准的SQL上做了扩展。数据模型数据库按照数据结构来组织、存储和管理数据，实际上，数据库一共有三种模型：层次模型网状模型关系模型：关系模型把数据看作是一个二维表格，任何数据都可以通过行号+...
mysql按字符串数字排序处理
hzau_itdog的博客
07-14 466
公司不知是谁设计的表菜单排序字段竟然设置成了字符串。 CREATE TABLE `s_menu` ( `ID` int(11) NOT NULL AUTO_INCREMENT, `PARENT_ID` int(11) DEFAULT NULL, `ORDER` varchar(5) DEFAULT NULL, `MENU_NAME` varchar(255) DEFAULT NULL, `MENU_URL` varchar(255) DEFAULT NULL, `MENU_ICO
Mysql字符串数字排序
weixin_40544268的博客
02-20 2522
如果您的 MySQL 数据库中的字符串只包含数字并且您想按数字顺序对它们进行排序，可以使用 MySQL 内置的 CAST() 函数将字符串转换为数字，然后对数字进行排序。
Mysql 数字字符串按照数字排序方法总结
canqiuxueying的博客
12-21 1万+
Mysql 数字字符串 按照 数字排序方法总结 第一种，直接在需要排序的数字字符串后面加*1 或者 +0 select * from table where 1 order by id*1 desc; select * from table where 1 order by id+0 desc; 第二种 FIND_IN_SET (大致原理是需要将 排序 的字段拼成一列 提前定制好序列，通过FIND_IN_SET 查询出来的是这个字段的顺序) SELECT FIND_IN_SET('1','1,2,3,4
Mysql大量数据快速排序方案
AlbenXie的博客
09-04 2516
日常开发中经常需要对数据进行排序，通常可以讲数据库中的数据获取到后通过程序在内存中进行排序，但是这样排序需要将排序内容从数据库中查询到内容，同时使用程序算法进行排序，然后将排序结果更新入数据库，这样排序效率较低，开发量较大，本例采用数据库本身自有属性进行大数据的快速排序，具体方案如下： 1、删除临时表 DROP TABLE IF EXISTS SORT_TEMP 2、创建临时
MySQL-字符串按照数值排序
JustDI0209的博客
07-21 3198
MySQL有个表字段设计的时候，设置为了varchar类型，存取的却是数值，后续有业务需要按照此字段排序，获取最大值。MySQL的varchar与int计算时，会转换为int。这两个函数都是用于格式转换的，二者没什么区别，以上4个sql的执行结果都为。这个并不是想要的结果。...
mysql 字符串数字型排序解决方案
絮落锦乡的博客
07-12 590
一、问题说明 操作mysql时字段定义为字符型，获取最大值或者是排序时，往往结果不如意，比如1-20 最大值往往是9 二、解决方案 1、在条件允许的情况下，将字段改为数字型 2、使用函数进行转换 cast(column as type); convert(column, type); type 值可以是： 浮点数 : decimal 整数 : signed 无符号整数 : unsigned ...
最全MySQL面试题集合
07-02
* 数字的比较比字符串要快很多 * 非自增 什么样的查询语句用不到索引 * 函数计算 * 数据类型转换 * like %开头 * or 运算 * 复合索引，没有左边字段索引 如何优化 * 经常被查询的区分度高的列做索引 * 数据量小...
mysql基本函数
11-20
MySQL 存储过程基本函数呈现了对字符串、转码、日期类型之间的转换。下面将详细介绍这些函数的用法和应用场景。 一、字符串类函数 1. CHARSET(str)：返回字符串的字符集。 CHARACTSET() 函数用于获取字符串的...
MySql基本查询、连接查询、子查询、正则表达查询讲解
08-24
“字符串”表示指定用来匹配的字符串，该字符串必须加单引号或双引号。 通配符: % 任意字符 [sql] view plain copy select * from STUDENT where STU_NAME LIKE '%王'; 表示匹配任何以王结尾的 [sql] view ...
oracle学习文档 笔记 全面 深刻 详细 通俗易懂 doc word格式 清晰 连接字符串
05-06
varchar2 1~4000字节 可变长度字符串，与CHAR类型相比，使用VARCHAR2可以节省磁盘空间，但查询效率没有char类型高 数值类型 Number(m,n) m(1~38) n(-84~127) 可以存储正数、负数、零、定点数和精度为38位的浮点数...
入门学习Linux常用必会60个命令实例详解doc/txt
06-09
出于安全考虑，输入账户密码时字符不会在屏幕上回显，光标也不移动。 登录后会看到下面这个界面（以超级用户为例）： [root@localhost root]# last login:Tue ,Nov 18 10:00:55 on vc/1 上面显示的是登录星期、月...
mysql排序字段包含中文和数字
H1212uhh的博客
12-06 2118
班级排序，如七年级1班、七年级2班、八年级1班、八年级3班、八年级6班等，这里需要对六、七、八、九诸如此类进行一个排序，表结构如下 这里采用的方法是把这一列的第一个字符取出来，然后自定义返回规则去进行排序field(str,str1,str2,str3,str4…) 字段str按照字符串1、字符串2、字符串3、字符串4的顺序返回查询到的结果集。如果表字段值str不存在，放在结果集的最前面如七年级1班，想要截取第一个字符，就是substring(user_name,1,1)，第一个参数写字段，第二个参数写从
MySQL字符串类型数字排序的三种解决方案
博客
11-18 720
原始： 方案： 1 2 3
MySql数据库排序问题
Darkness萌妻的小窝
02-21 208
select authseq , authstate , transtime   from mgt.mgt_mauthqueue  ORDER BY  CASE  WHEN authstate='1' THEN 1  WHEN authstate='0' THEN 2  WHEN authstate='5' THEN 3  ELSE 4   END       ,  transtime DESC...
pandas 根据某一列排序（sort_values）
热门推荐
天空没有留下我的痕迹，但我已飞过！
03-26 3万+
官方文档： https://pandas.pydata.org/pandas-docs/stable/generated/pandas.DataFrame.sort_values.html df.sort_values(by="XXXX" , ascending=False) by 指定列 ascending #coding=utf-8 import pandas as pd import num...
mysql数字型排序规则,MySQL数据类型优化原则
weixin_35679269的博客
03-24 538
MySQL支持的数据类型很多，选择正确的数据类型对于高性能至关重要。下面几个简单的原则都有助于做出更好的选择。更小的通常更好应该尽量使用可以正确储存数据的最小数据类型。更小的数据类型通常更快，因为它们占用更少的磁盘、内存和CPU缓存，并且处理时需要的CPU周期也更少。如果无法确定哪个数据类型时最好的，就选择你认为不会超过范围的最小类型。简单就好简单数据类型的操作通常需要更少的CPU周期。例如，整形...
mysql获得以s开头,使用MySQL Regex仅查找以数字开头的字符串？
weixin_39884832的博客
03-18 564
要查找以数字开头的字符串，请使用正则表达式。让我们首先创建一个表-mysql>createtableDemoTable(Idvarchar(200));使用插入命令在表中插入记录-mysql>insertintoDemoTablevalues('123User');mysql>insertintoDemoTablevalues('_$123User');m...
MySQL-索引：聚集索引、覆盖索引、组合索引、前缀索引、唯一索引
最新发布
睡不醒的每天
06-25 566
这意味着表中的行是按id的升序物理存储的，并且每个叶子节点包含了完整的行数据（包括username, email, created_at）。当你执行如下查询时，同样以上述的idx_username_email为例，它是一个基于username和email两个列创建的组合索引。在users表中，id列已经是一个主键，自动带有唯一约束。不仅包括查询列，还包括结果集中所需的其他列（如在SELECT列表中的列）。，无需回表获取其他列数据，这就是一个覆盖索引的例子。在数据库中，聚集索引决定了表数据行的物理存储顺序。
MySQL中为数字的字符串排序
06-08
在 MySQL 中，为数字的字符串排序可以使用 ORDER BY 子句结合 CAST 或 CONVERT 函数来实现。这两个函数可以将字符串转换为数字，然后再进行排序。 例如，假设有一个表 t，其中包含一个名为 num 的为数字的字符串字段，现在需要按照 num 字段进行升序排序。可以使用以下 SQL 语句来实现： ``` SELECT * FROM t ORDER BY CAST(num AS UNSIGNED) ASC; ``` 在上述 SQL 语句中，CAST(num AS UNSIGNED) 将 num 字段转换为无符号整数类型，然后按照转换后的结果进行排序。如果使用的是有符号整数类型，可以使用 SIGNED 关键字替换 UNSIGNED。 另外，也可以使用 CONVERT 函数来实现相同的功能，例如： ``` SELECT * FROM t ORDER BY CONVERT(num, UNSIGNED) ASC; ``` 需要注意的是，在使用 CAST 或 CONVERT 函数时，如果字符串中包含非数字字符，将会报错。因此，在使用之前需要先确保字符串均为数字类型。

“相关推荐”对你有帮助么？

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值