mysql数字开头字符串排序

news/2024/4/30 5:56:46/文章来源: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 TransferSource Server         : localSource Server Type    : MySQLSource Server Version : 80029Source Host           : localhost:3306Source Schema         : mcs_saasTarget Server Type    : MySQLTarget Server Version : 80029File Encoding         : 65001Date: 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 
FROMbuilding 
ORDER BYNAME + 0, NAME

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

本文来自互联网用户投稿，该文观点仅代表作者本人，不代表本站立场。本站仅提供信息存储空间服务，不拥有所有权，不承担相关法律责任。如若转载，请注明出处：http://www.luyixian.cn/news_show_332629.aspx

如若内容造成侵权/违法违规/事实不符，请联系dt猫网进行投诉反馈email:809451989@qq.com，一经查实，立即删除！

相关文章

Redis 最佳实践：7 个维度 + 43 条使用规范，带你彻底玩转 Redis | 附实践清单

Redis 最佳实践：7 个维度 + 43 条使用规范，带你彻底玩转 Redis | 附实践清单

目录​​​​​​​ 前言 如何使用 Redis 更节省内存？ 1) 控制 key 的长度 2) 避免存储 bigkey 3) 选择合适的数据类型 4) 把 Redis 当作缓存使用 5) 实例设置 maxmemory 淘汰策略 6) 数据压缩后写入 Redis 如何持续发挥 Redis 的高性能？ 1) …
阅读更多...
HDFS与MapResource笔记

HDFS与MapResource笔记

客户端向NN请求上传文件 NN回应可以上传 请求上传块,返回DN 所以后面就比较慢 找最近的服务器进行 64K发到1节点,1节点立刻发给2节点,同时1节点自动开始落盘,这里,3个节点是同时落盘的. 因为缓存是在内存中,而持久化是将数据存到磁盘上. 副本节点选择: 1.安全:放不同机架 2.速…
阅读更多...
【实战总结】SpringMVC架构升级SpringCloudAlibaba

【实战总结】SpringMVC架构升级SpringCloudAlibaba

升级目标 SpringMVCDubboZookeeper分布式架构改为Spring Cloud Alibaba微服务 技术框架:Spring Boot 2.7.2、Spring Cloud 2021.0.3 & Alibaba 2021.0.1.0 容器:Tomcat 9.0.65 JDK:1.8 配置中心:Nacos 2.0.4 消息队列:RocetMQ 4.9.3 配置中心:Apollo 11.0 缓存: Redis 4.0…
阅读更多...
mmdet3d预处理（下）| train pipeline

mmdet3d预处理（下）| train pipeline

mmdet3d预处理（下）—— train pipeline 文章目录 mmdet3d预处理（下）—— train pipeline基类 BaseTransformLoadPointsFromFileLoadAnnotations3D标签信息：源码 ObjectSample源码 ObjectNoise输入参数源码RandomFlip3D…
阅读更多...
Loadrunner结合Fiddler实现脚本的录制

Loadrunner结合Fiddler实现脚本的录制

Loadrunner一直被业内认为是最好用的性能测试工具，行业大哥大, 但是用过Loadrunner的朋友都知道，工具功能的确牛，但实际使用过程中总会有一些困扰新手的问题，无法录制脚本， 如遇到Loadrunner不支持的IE版本、对Chrome、…
阅读更多...
2023年 大二，我拿到了 3 家大厂 offer，为什么我要安利你去实习？

2023年 大二，我拿到了 3 家大厂 offer，为什么我要安利你去实习？

关于 2023年 大二，我拿到了 3 家大厂 offer 这件事 2023年，在大二那年寒假的时候，提前自学完，觉得自己知识储备差不多了，开始投递软件开发实习，刚开始的时候真的是屡遭打击，首先因为本身是双非二…
阅读更多...
如何通过边缘智能网关实现暴雨灾害监测预警

如何通过边缘智能网关实现暴雨灾害监测预警

随着台风季来临，暴雨灾害也进入到频发阶段，给村镇和城市居民都造成诸多人身和财产损失。针对南方台风季的水灾防治，物联网技术派上大用场，本篇就基于边缘智能网关的数采方案，简单介绍对暴雨导致的洪涝、内涝的监测和预…
阅读更多...
2023Testing Expo| 怿星科技展品抢先看（第一弹）

2023Testing Expo| 怿星科技展品抢先看（第一弹）

8月9日-11日，2023汽车测试及质量监控博览会将于上海世博展览馆1号馆举行，本次展会将展示测试和验证技术在整车、零部件和系统开发领域中的新发展、新产品和新解决方案。怿星科技将携最新的ETH测试、智驾测试、PPS测试等方案亮相测试展，届时欢…
阅读更多...
【文末送书 - 数据分析之pandas篇④】- DataFrame数据合并

【文末送书 - 数据分析之pandas篇④】- DataFrame数据合并

向阳花花花花 - 个人主页 迄今所有人生都大写着失败，但并不妨碍我继续向前 Python 数据分析专栏 正在火热更新中 🔥 文章目录 一、concat二、append三、merge3.1 没有属性相同时3.2 只有一个属性相同时1.一对一合并2.一对多合并3.多对多合并 3.3 有多个…
阅读更多...
品牌营销策略：如何有效打造品牌知名度与口碑？

品牌营销策略：如何有效打造品牌知名度与口碑？

品牌营销策略是企业在市场竞争中脱颖而出的重要手段，它能够帮助企业树立品牌形象，提升品牌知名度，增强品牌影响力，从而获得更多的市场份额和利润。那么，如何制定一套有效的品牌营销策略呢？以下是一秒推小编…
阅读更多...
Spring【AOP】

Spring【AOP】

AOP-面向切面编程 AOP&#xff1a;面向切面编程&#xff0c;通过预编译方式和运行期动态代理实现程序功能的统一维护的一种技术。 SpringAop中&#xff0c;通过Advice定义横切逻辑&#xff0c;并支持5种类型的Advice&#xff1a; 导入依赖 <dependency><groupId>…
阅读更多...
webpack打包之 copy-webpack-plugin

webpack打包之 copy-webpack-plugin

copy-webpack-plugin 打包复制文件插件。 1、什么时候要使用&#xff1f; 在离线应用中&#xff0c;前端所有文件都需在在本地&#xff0c;有些文件&#xff08;比如iconFont以及一些静态img)需要转为离线文件&#xff0c;这些文件可以直接引用更方便些&#xff0c;这就需要在打…
阅读更多...
Redis学习（三）持久化机制、分布式缓存、多级缓存、Redis实战经验

Redis学习（三）持久化机制、分布式缓存、多级缓存、Redis实战经验

文章目录 分布式缓存Redis持久化RDB持久化AOF持久化 Redis主从Redis数据同步原理全量同步增量同步 Redis哨兵哨兵的作用和原理sentinel&#xff08;哨兵&#xff09;的三个作用是什么&#xff1f;sentinel如何判断一个Redis实例是否健康&#xff1f;master出现故障后&#xff0…
阅读更多...
QT之智能指针

QT之智能指针

如果没有智能指针&#xff0c;程序员必须保证new对象能在正确的时机delete&#xff0c;四处编写异常捕获代码以释放资源&#xff0c;而智能指针则可以在退出作用域时(不管是正常流程离开或是因异常离开)总调用delete来析构在堆上动态分配的对象。 来看看一个野指针例子 程序将会…
阅读更多...
vue的生命周期和执行顺序

vue的生命周期和执行顺序

1&#xff0c;Vue 生命周期都有哪些&#xff1f; 序号生命周期描述1beforecreate创建前vue实例初始化阶段&#xff0c;不可以访问data,methods&#xff1b; 此时打印出的this是undefined&#xff1b;2created创建后vue实例初始化完成&#xff0c;可以访问data&#xff0c;meth…
阅读更多...
truffle 进行智能合约测试

truffle 进行智能合约测试

0字 本方法使用了可视化软件Ganache 前两步与不使用可视化工具的步骤是一样的&#xff08;有道云笔记&#xff09;&#xff0c;到第三步的时候需要注意&#xff1a; 在truffle插件下找到networks目录&#xff0c;提前打开Ganache软件 在Ganache中选择连接或者新建&#xff0…
阅读更多...
Django实现接口自动化平台（十二）自定义函数模块DebugTalks 序列化器及视图【持续更新中】

Django实现接口自动化平台（十二）自定义函数模块DebugTalks 序列化器及视图【持续更新中】

上一章&#xff1a; Django实现接口自动化平台&#xff08;十一&#xff09;项目模块Projects序列化器及视图【持续更新中】_做测试的喵酱的博客-CSDN博客 本章是项目的一个分解&#xff0c;查看本章内容时&#xff0c;要结合整体项目代码来看&#xff1a; python django vue…
阅读更多...
Redis : zmalloc.h:50:31: 致命错误：jemalloc/jemalloc.h：没有那个文件或目录

Redis : zmalloc.h:50:31: 致命错误：jemalloc/jemalloc.h：没有那个文件或目录

In file included from adlist.c:34:0: zmalloc.h:50:31: 致命错误&#xff1a;jemalloc/jemalloc.h&#xff1a;没有那个文件或目录 #include <jemalloc/jemalloc.h> 解决 : 如上图使用命令 make MALLOClibc
阅读更多...
视频卡通化技术路线

视频卡通化技术路线

神经风格迁移&#xff1a;用深度神经网络生成风格化图像&#xff0c;通过捕获到的图像中的内容表征对输出图像做约束&#xff0c;就是输入图像和目标图像通过vgg提取的特征做约束。 GAN图像翻译&#xff1a;Image-to-image translation&#xff0c;主要基于conditional GAN&am…
阅读更多...
Redis分布式锁的演变历程

Redis分布式锁的演变历程

什么时候用分布式锁 当并发去读写一个【共享资源】的时候&#xff0c;我们为了保证数据的正确&#xff0c;需要控制同一时刻只有一个线程访问。 分布式锁就是用来控制同一时刻&#xff0c;只有一个 JVM 进程中的一个线程可以访问被保护的资源。 分布式锁入门 分布式锁应该满足…
阅读更多...
推荐文章
最新文章

Copyright @ 2022~2023

友情链接： 我的编程经验分享 一条长河网 尧图网站开发 尧图建网站 广利置业