文档章节

省市区各级代码sql导出

hey胡一天
 hey胡一天
发布于 2017/09/14 17:34
字数 2608
阅读 128
收藏 1

创建表及插入数据

DROP TABLE IF EXISTS `tag_cities`;

CREATE TABLE `tag_cities` (
	`id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, 
	`code` varchar(20) NOT NULL, 
	`name` varchar(20) NOT NULL, 
	`parent` int(11) NOT NULL DEFAULT '0', 
	PRIMARY KEY (`id`)
) ENGINE = MyISAM AUTO_INCREMENT = 480 CHARSET = utf8;

INSERT INTO `tag_cities` (`id`, `code`, `name`, `parent`)
VALUES (1, '10101000', '广东', 0),
	(2, '10102000', '北京', 0),
	(3, '10103000', '上海', 0),
	(4, '10104000', '天津', 0),
	(5, '10105000', '重庆', 0),
	(6, '10106000', '安徽', 0),
	(7, '10107000', '福建', 0),
	(8, '10108000', '甘肃', 0),
	(9, '10109000', '广西', 0),
	(10, '10110000', '贵州', 0),
	(11, '10111000', '海南', 0),
	(12, '10112000', '河北', 0),
	(13, '10113000', '河南', 0),
	(14, '10114000', '黑龙江', 0),
	(15, '10115000', '湖北', 0),
	(16, '10116000', '湖南', 0),
	(17, '10117000', '吉林', 0),
	(18, '10118000', '江苏', 0),
	(19, '10119000', '江西', 0),
	(20, '10120000', '辽宁', 0),
	(21, '10121000', '内蒙古', 0),
	(22, '10122000', '宁夏', 0),
	(23, '10123000', '青海', 0),
	(24, '10124000', '山东', 0),
	(25, '10125000', '山西', 0),
	(26, '10126000', '陕西', 0),
	(27, '10127000', '四川', 0),
	(28, '10128000', '西藏', 0),
	(29, '10129000', '新疆', 0),
	(30, '10130000', '云南', 0),
	(31, '10131000', '浙江', 0),
	(32, '10132000', '澳门', 0),
	(33, '10133000', '香港', 0),
	(34, '10134000', '台湾', 0),
	(35, '10101002', '广州', 1),
	(36, '10101003', '佛山', 1),
	(37, '10101004', '湛江', 1),
	(38, '10101005', '珠海', 1),
	(39, '10101006', '肇庆', 1),
	(40, '10101007', '东莞', 1),
	(41, '10101008', '惠州', 1),
	(42, '10101011', '中山', 1),
	(43, '10101012', '茂名', 1),
	(44, '10101013', '汕头', 1),
	(45, '10101014', '梅州', 1),
	(46, '10101015', '韶关', 1),
	(47, '10101016', '江门', 1),
	(48, '10101018', '清远', 1),
	(49, '10101020', '潮州', 1),
	(50, '10101022', '阳江', 1),
	(51, '10101023', '河源', 1),
	(52, '10101026', '揭阳', 1),
	(53, '10101028', '汕尾', 1),
	(54, '10101068', '云浮', 1),
	(55, '10101201', '深圳', 1),
	(56, '10102001', '东城区', 2),
	(57, '10102002', '西城区', 2),
	(58, '10102005', '朝阳区', 2),
	(59, '10102006', '丰台区', 2),
	(60, '10102007', '石景山区', 2),
	(61, '10102008', '海淀区', 2),
	(62, '10102009', '门头沟区', 2),
	(63, '10102010', '房山区', 2),
	(64, '10102011', '通州区', 2),
	(65, '10102012', '顺义区', 2),
	(66, '10102013', '昌平区', 2),
	(67, '10102014', '大兴区', 2),
	(68, '10102015', '怀柔区', 2),
	(69, '10102016', '平谷区', 2),
	(70, '10102017', '密云', 2),
	(71, '10102018', '延庆', 2),
	(72, '10103001', '浦东新区', 3),
	(73, '10103002', '徐汇区', 3),
	(74, '10103003', '长宁区', 3),
	(75, '10103004', '普陀区', 3),
	(76, '10103005', '闸北区', 3),
	(77, '10103006', '虹口区', 3),
	(78, '10103007', '杨浦区', 3),
	(79, '10103008', '黄浦区', 3),
	(80, '10103010', '静安区', 3),
	(81, '10103011', '宝山区', 3),
	(82, '10103012', '闵行区', 3),
	(83, '10103013', '嘉定区', 3),
	(84, '10103014', '金山区', 3),
	(85, '10103015', '松江区', 3),
	(86, '10103016', '青浦区', 3),
	(87, '10103017', '崇明', 3),
	(88, '10103018', '奉贤区', 3),
	(89, '10104002', '武清区', 4),
	(90, '10104003', '宁河', 4),
	(91, '10104005', '宝坻区', 4),
	(92, '10104006', '静海', 4),
	(93, '10104007', '蓟县', 4),
	(94, '10104008', '和平区', 4),
	(95, '10104009', '河东区', 4),
	(96, '10104010', '河西区', 4),
	(97, '10104011', '南开区', 4),
	(98, '10104012', '河北区', 4),
	(99, '10104013', '红桥区', 4),
	(100, '10104014', '滨海新区', 4),
	(101, '10104017', '东丽区', 4),
	(102, '10104018', '西青区', 4),
	(103, '10104019', '北辰区', 4),
	(104, '10104020', '津南区', 4),
	(105, '10105002', '奉节', 5),
	(106, '10105003', '武隆', 5),
	(107, '10105004', '忠县', 5),
	(108, '10105005', '巫山', 5),
	(109, '10105006', '开县', 5),
	(110, '10105007', '永川区', 5),
	(111, '10105008', '荣昌', 5),
	(112, '10105010', '铜梁', 5),
	(113, '10105012', '石柱', 5),
	(114, '10105013', '合川区', 5),
	(115, '10105015', '南川区', 5),
	(116, '10105016', '长寿区', 5),
	(117, '10105017', '巫溪', 5),
	(118, '10105018', '黔江区', 5),
	(119, '10105019', '云阳', 5),
	(120, '10105020', '垫江', 5),
	(121, '10105021', '梁平', 5),
	(122, '10105023', '大足区', 5),
	(123, '10105024', '北碚区', 5),
	(124, '10105025', '璧山', 5),
	(125, '10105026', '江北区', 5),
	(126, '10105027', '潼南', 5),
	(127, '10105028', '涪陵区', 5),
	(128, '10105029', '江津区', 5),
	(129, '10105030', '丰都', 5),
	(130, '10105032', '城口', 5),
	(131, '10105033', '綦江区', 5),
	(132, '10105034', '渝中区', 5),
	(133, '10105035', '大渡口区', 5),
	(134, '10105036', '沙坪坝区', 5),
	(135, '10105037', '九龙坡区', 5),
	(136, '10105038', '南岸区', 5),
	(137, '10105040', '渝北区', 5),
	(138, '10105041', '巴南区', 5),
	(139, '10105042', '万州区', 5),
	(140, '10105043', '秀山', 5),
	(141, '10105044', '酉阳', 5),
	(142, '10105045', '彭水', 5),
	(143, '10106001', '合肥', 6),
	(144, '10106002', '淮南', 6),
	(145, '10106003', '蚌埠', 6),
	(146, '10106004', '宿州', 6),
	(147, '10106005', '阜阳', 6),
	(148, '10106006', '六安', 6),
	(149, '10106008', '滁州', 6),
	(150, '10106009', '芜湖', 6),
	(151, '10106011', '安庆', 6),
	(152, '10106012', '黄山', 6),
	(153, '10106013', '铜陵', 6),
	(154, '10106042', '淮北', 6),
	(155, '10106072', '亳州', 6),
	(156, '10106075', '马鞍山', 6),
	(157, '10106079', '池州', 6),
	(158, '10106080', '宣城', 6),
	(159, '10107001', '福州', 7),
	(160, '10107002', '厦门', 7),
	(161, '10107003', '泉州', 7),
	(162, '10107004', '南平', 7),
	(163, '10107007', '漳州', 7),
	(164, '10107008', '龙岩', 7),
	(165, '10107009', '三明', 7),
	(166, '10107010', '莆田', 7),
	(167, '10107013', '宁德', 7),
	(168, '10108001', '兰州', 8),
	(169, '10108002', '张掖', 8),
	(170, '10108003', '武威', 8),
	(171, '10108004', '酒泉', 8),
	(172, '10108006', '金昌', 8),
	(173, '10108007', '天水', 8),
	(174, '10108008', '定西', 8),
	(175, '10108009', '平凉', 8),
	(176, '10108012', '甘南', 8),
	(177, '10108023', '嘉峪关', 8),
	(178, '10108064', '庆阳', 8),
	(179, '10108078', '白银', 8),
	(180, '10108084', '陇南', 8),
	(181, '10108085', '临夏', 8),
	(182, '10109001', '南宁', 9),
	(183, '10109002', '柳州', 9),
	(184, '10109003', '钦州', 9),
	(185, '10109004', '百色', 9),
	(186, '10109005', '玉林', 9),
	(187, '10109006', '防城港', 9),
	(188, '10109007', '桂林', 9),
	(189, '10109008', '梧州', 9),
	(190, '10109009', '河池', 9),
	(191, '10109010', '北海', 9),
	(192, '10109014', '贵港', 9),
	(193, '10109018', '来宾', 9),
	(194, '10109083', '崇左', 9),
	(195, '10109089', '贺州', 9),
	(196, '10110001', '贵阳', 10),
	(197, '10110002', '六盘水', 10),
	(198, '10110006', '安顺', 10),
	(199, '10110007', '遵义', 10),
	(200, '10110021', '毕节', 10),
	(201, '10110055', '铜仁', 10),
	(202, '10110082', '黔西南', 10),
	(203, '10110083', '黔东南', 10),
	(204, '10110084', '黔南', 10),
	(205, '10111001', '海口', 11),
	(206, '10111002', '三亚', 11),
	(207, '10111022', '省直辖县级', 11),
	(208, '10112001', '石家庄', 12),
	(209, '10112002', '衡水', 12),
	(210, '10112003', '邢台', 12),
	(211, '10112004', '邯郸', 12),
	(212, '10112005', '沧州', 12),
	(213, '10112006', '唐山', 12),
	(214, '10112007', '廊坊', 12),
	(215, '10112008', '秦皇岛', 12),
	(216, '10112009', '承德', 12),
	(217, '10112010', '保定', 12),
	(218, '10112011', '张家口', 12),
	(219, '10113001', '郑州', 13),
	(220, '10113002', '新乡', 13),
	(221, '10113003', '安阳', 13),
	(222, '10113004', '许昌', 13),
	(223, '10113005', '驻马店', 13),
	(224, '10113006', '漯河', 13),
	(225, '10113007', '信阳', 13),
	(226, '10113008', '周口', 13),
	(227, '10113009', '洛阳', 13),
	(228, '10113010', '平顶山', 13),
	(229, '10113011', '三门峡', 13),
	(230, '10113012', '南阳', 13),
	(231, '10113013', '开封', 13),
	(232, '10113014', '商丘', 13),
	(233, '10113015', '鹤壁', 13),
	(234, '10113016', '濮阳', 13),
	(235, '10113017', '焦作', 13),
	(236, '10113126', '省直辖县级', 13),
	(237, '10114001', '哈尔滨', 14),
	(238, '10114002', '绥化', 14),
	(239, '10114003', '佳木斯', 14),
	(240, '10114004', '牡丹江', 14),
	(241, '10114005', '齐齐哈尔', 14),
	(242, '10114007', '大庆', 14),
	(243, '10114008', '大兴安岭', 14),
	(244, '10114009', '鸡西', 14),
	(245, '10114020', '鹤岗', 14),
	(246, '10114024', '双鸭山', 14),
	(247, '10114042', '伊春', 14),
	(248, '10114053', '黑河', 14),
	(249, '10114067', '七台河', 14),
	(250, '10115001', '武汉', 15),
	(251, '10115002', '黄石', 15),
	(252, '10115004', '鄂州', 15),
	(253, '10115006', '咸宁', 15),
	(254, '10115007', '十堰', 15),
	(255, '10115008', '宜昌', 15),
	(256, '10115009', '恩施', 15),
	(257, '10115010', '荆州', 15),
	(258, '10115011', '黄冈', 15),
	(259, '10115012', '荆门', 15),
	(260, '10115013', '孝感', 15),
	(261, '10115014', '襄阳', 15),
	(262, '10115062', '随州', 15),
	(263, '10115085', '省直辖县级', 15),
	(264, '10116001', '长沙', 16),
	(265, '10116002', '株洲', 16),
	(266, '10116003', '益阳', 16),
	(267, '10116004', '岳阳', 16),
	(268, '10116005', '常德', 16),
	(269, '10116007', '娄底', 16),
	(270, '10116008', '怀化', 16),
	(271, '10116009', '衡阳', 16),
	(272, '10116010', '邵阳', 16),
	(273, '10116011', '郴州', 16),
	(274, '10116013', '张家界', 16),
	(275, '10116014', '湘潭', 16),
	(276, '10116075', '永州', 16),
	(277, '10116097', '湘西', 16),
	(278, '10117001', '长春', 17),
	(279, '10117002', '吉林', 17),
	(280, '10117004', '通化', 17),
	(281, '10117006', '四平', 17),
	(282, '10117007', '白城', 17),
	(283, '10117008', '松原', 17),
	(284, '10117028', '辽源', 17),
	(285, '10117048', '白山', 17),
	(286, '10117049', '延边', 17),
	(287, '10118001', '南京', 18),
	(288, '10118002', '苏州', 18),
	(289, '10118003', '无锡', 18),
	(290, '10118004', '徐州', 18),
	(291, '10118005', '常州', 18),
	(292, '10118006', '镇江', 18),
	(293, '10118007', '连云港', 18),
	(294, '10118009', '盐城', 18),
	(295, '10118010', '扬州', 18),
	(296, '10118011', '南通', 18),
	(297, '10118016', '淮安', 18),
	(298, '10118051', '泰州', 18),
	(299, '10118063', '宿迁', 18),
	(300, '10119001', '南昌', 19),
	(301, '10119002', '九江', 19),
	(302, '10119003', '景德镇', 19),
	(303, '10119004', '上饶', 19),
	(304, '10119005', '鹰潭', 19),
	(305, '10119006', '宜春', 19),
	(306, '10119007', '萍乡', 19),
	(307, '10119008', '赣州', 19),
	(308, '10119009', '吉安', 19),
	(309, '10119010', '抚州', 19),
	(310, '10119040', '新余', 19),
	(311, '10120001', '沈阳', 20),
	(312, '10120002', '铁岭', 20),
	(313, '10120003', '抚顺', 20),
	(314, '10120004', '鞍山', 20),
	(315, '10120005', '营口', 20),
	(316, '10120006', '大连', 20),
	(317, '10120007', '本溪', 20),
	(318, '10120008', '丹东', 20),
	(319, '10120009', '锦州', 20),
	(320, '10120010', '朝阳', 20),
	(321, '10120011', '阜新', 20),
	(322, '10120012', '盘锦', 20),
	(323, '10120013', '辽阳', 20),
	(324, '10120014', '葫芦岛', 20),
	(325, '10121001', '呼和浩特', 21),
	(326, '10121003', '包头', 21),
	(327, '10121005', '乌海', 21),
	(328, '10121008', '赤峰', 21),
	(329, '10121011', '通辽', 21),
	(330, '10121089', '锡林郭勒盟', 21),
	(331, '10121090', '阿拉善盟', 21),
	(332, '10121091', '兴安盟', 21),
	(333, '10121092', '鄂尔多斯', 21),
	(334, '10121093', '呼伦贝尔', 21),
	(335, '10121094', '巴彦淖尔', 21),
	(336, '10121095', '乌兰察布', 21),
	(337, '10122001', '银川', 22),
	(338, '10122002', '石嘴山', 22),
	(339, '10122003', '固原', 22),
	(340, '10122010', '吴忠', 22),
	(341, '10122011', '中卫', 22),
	(342, '10123001', '西宁', 23),
	(343, '10123002', '果洛', 23),
	(344, '10123003', '玉树', 23),
	(345, '10123005', '海西', 23),
	(346, '10123045', '海东', 23),
	(347, '10123046', '海北', 23),
	(348, '10123047', '黄南', 23),
	(349, '10123048', '海南', 23),
	(350, '10124001', '青岛', 24),
	(351, '10124002', '威海', 24),
	(352, '10124003', '济南', 24),
	(353, '10124004', '淄博', 24),
	(354, '10124005', '聊城', 24),
	(355, '10124006', '德州', 24),
	(356, '10124007', '东营', 24),
	(357, '10124008', '潍坊', 24),
	(358, '10124009', '烟台', 24),
	(359, '10124011', '泰安', 24),
	(360, '10124012', '菏泽', 24),
	(361, '10124013', '临沂', 24),
	(362, '10124014', '枣庄', 24),
	(363, '10124015', '济宁', 24),
	(364, '10124016', '日照', 24),
	(365, '10124018', '滨州', 24),
	(366, '10124068', '莱芜', 24),
	(367, '10125001', '太原', 25),
	(368, '10125003', '忻州', 25),
	(369, '10125005', '大同', 25),
	(370, '10125006', '临汾', 25),
	(371, '10125008', '运城', 25),
	(372, '10125009', '阳泉', 25),
	(373, '10125010', '长治', 25),
	(374, '10125011', '晋城', 25),
	(375, '10125034', '朔州', 25),
	(376, '10125107', '晋中', 25),
	(377, '10125108', '吕梁', 25),
	(378, '10126001', '西安', 26),
	(379, '10126002', '渭南', 26),
	(380, '10126003', '延安', 26),
	(381, '10126005', '榆林', 26),
	(382, '10126006', '宝鸡', 26),
	(383, '10126007', '安康', 26),
	(384, '10126008', '汉中', 26),
	(385, '10126010', '铜川', 26),
	(386, '10126011', '咸阳', 26),
	(387, '10126098', '商洛', 26),
	(388, '10127001', '成都', 27),
	(389, '10127002', '乐山', 27),
	(390, '10127003', '凉山', 27),
	(391, '10127005', '绵阳', 27),
	(392, '10127007', '阿坝', 27),
	(393, '10127008', '雅安', 27),
	(394, '10127009', '甘孜', 27),
	(395, '10127010', '广元', 27),
	(396, '10127011', '南充', 27),
	(397, '10127013', '内江', 27),
	(398, '10127014', '自贡', 27),
	(399, '10127015', '宜宾', 27),
	(400, '10127016', '泸州', 27),
	(401, '10127017', '攀枝花', 27),
	(402, '10127018', '德阳', 27),
	(403, '10127021', '资阳', 27),
	(404, '10127056', '眉山', 27),
	(405, '10127070', '广安', 27),
	(406, '10127117', '遂宁', 27),
	(407, '10127125', '巴中', 27),
	(408, '10127137', '达州', 27),
	(409, '10128001', '拉萨', 28),
	(410, '10128002', '那曲', 28),
	(411, '10128003', '昌都', 28),
	(412, '10128004', '山南', 28),
	(413, '10128005', '日喀则', 28),
	(414, '10128006', '阿里', 28),
	(415, '10128007', '林芝', 28),
	(416, '10129001', '乌鲁木齐', 29),
	(417, '10129004', '克拉玛依', 29),
	(418, '10129006', '阿勒泰', 29),
	(419, '10129007', '巴音郭楞', 29),
	(420, '10129008', '哈密', 29),
	(421, '10129009', '吐鲁番', 29),
	(422, '10129010', '阿克苏', 29),
	(423, '10129011', '喀什', 29),
	(424, '10129012', '和田', 29),
	(425, '10129017', '昌吉', 29),
	(426, '10129086', '塔城', 29),
	(427, '10129088', '克孜勒苏', 29),
	(428, '10129089', '博尔塔拉', 29),
	(429, '10129090', '伊犁', 29),
	(430, '10129091', '自治区直辖县级', 29),
	(431, '10130001', '昆明', 30),
	(432, '10130002', '曲靖', 30),
	(433, '10130003', '昭通', 30),
	(434, '10130005', '文山', 30),
	(435, '10130007', '大理', 30),
	(436, '10130008', '楚雄', 30),
	(437, '10130009', '临沧', 30),
	(438, '10130010', '保山', 30),
	(439, '10130011', '玉溪', 30),
	(440, '10130030', '丽江', 30),
	(441, '10130052', '普洱', 30),
	(442, '10130098', '红河州', 30),
	(443, '10130127', '西双版纳', 30),
	(444, '10130128', '德宏', 30),
	(445, '10130129', '怒江', 30),
	(446, '10130130', '迪庆', 30),
	(447, '10131001', '杭州', 31),
	(448, '10131002', '温州', 31),
	(449, '10131003', '宁波', 31),
	(450, '10131004', '绍兴', 31),
	(451, '10131005', '湖州', 31),
	(452, '10131006', '嘉兴', 31),
	(453, '10131009', '金华', 31),
	(454, '10131010', '丽水', 31),
	(455, '10131011', '衢州', 31),
	(456, '10131012', '台州', 31),
	(457, '10131015', '舟山', 31),
	(458, '10132001', '澳门', 32),
	(459, '10133001', '香港岛', 33),
	(460, '10133002', '九龙', 33),
	(461, '10133003', '新界', 33),
	(462, '10134004', '云林', 34),
	(463, '10134013', '新北', 34),
	(464, '10134030', '台北', 34),
	(465, '10134031', '高雄', 34),
	(466, '10134032', '桃园', 34),
	(467, '10134033', '新竹', 34),
	(468, '10134034', '宜兰', 34),
	(469, '10134035', '苗栗', 34),
	(470, '10134036', '屏东', 34),
	(471, '10134037', '花莲', 34),
	(472, '10134038', '彰化', 34),
	(473, '10134039', '南投', 34),
	(474, '10134040', '台东', 34),
	(475, '10134041', '基隆', 34),
	(476, '10134042', '台中', 34),
	(477, '10134043', '台南', 34),
	(478, '10134044', '嘉义', 34),
	(479, '10134045', '澎湖', 34);

© 著作权归作者所有

hey胡一天
粉丝 4
博文 13
码字总数 24203
作品 0
南昌
程序员
私信 提问
javaWeb数据库动态加载全国省市区三级联动

demo源码下载地址:https://git.oschina.net/zhengweishan/GetProvinceCityArea 首先声明一下,全国省市区三级联动有很多的插件。没有必要这么麻烦的把省市区存到数据库,然后再获取。这样缺...

火龙战士
2015/04/16
17.3K
8
三级联动下拉选择省市区sql查询求助

自关联不怎么会 查询【region_info】省市区信息表 查询条件: 【level_type】 = 1 【status】 = 1 按【id】 正序 排列 select name,id from region_info where level_type=1 and status=1 or...

idiot_ioi
2016/02/26
2.1K
3
AOSuite V2.3 发布,JavaEE 开发套件

写在最前面 为了方便搜素引擎检索AOS 更名为 AOSuite。 AOSuite V2.3 发布了,这个版本包含9个新增/修复。 版本变更日志 【优化】优化了缓存Key的存储结构。 【优化】优化了配置文件中扫描包...

神盾局-局座
2016/12/10
411
1
有没有关于mysql 简单入门的书籍?(sql只会几张表简单left join下)

平时最多用left join多连几张表查询,子查询也用的比较少(一条sql出现多个select就慌。存储过程也不会) 索引也没怎么用过。 像省市区三级表;订单表,订单详细表;班级分组排名平均分;消费...

今天天气不错啊
03/07
295
3
AOSuite V2.3 发布,JavaEE 开发套件

写在最前面 为了方便搜素引擎检索AOS 更名为 AOSuite。 AOSuite V2.3 发布了,这个版本包含9个新增/修复。 版本变更日志 【优化】优化了缓存Key的存储结构。 【优化】优化了配置文件中扫描包...

阿老表
2016/12/02
3.1K
1

没有更多内容

加载失败,请刷新页面

加载更多

SpringBoot 操作ActiveMQ

一、消息队列中间件介绍 消息队列中间件是分布式系统中重要的组件,主要解决应用耦合、异步消息、流量削锋等问题,实现高性能、高可用、可伸缩和最终一致性架构,是大型分布式系统不可缺少的...

zw965
4分钟前
1
0
xx

为什么会引入Storage(sessionStorage,localStorage,globalStorage) Web storage的目的是克服由cookie带来的限制,当数据需要严格控制在客户端上时,无须持续将数据发回服务器。主要是提供一...

五公里
12分钟前
2
0
Qt编写自定义控件57-直方波形图

一、前言 直方波形图控件非原创控件,控件大全中大概有20-30个控件非自己原创,而是参考了网上开源的代码,自己加以整理和完善,新增了插件的代码使得可以直接集成到QtDesigner或者QtCreator...

飞扬青云
13分钟前
1
0
或许你不知道的10条SQL技巧

这几天在写索引,想到一些有意思的TIPS,希望大家有收获。 一、一些常见的SQL实践 (1)负向条件查询不能使用索引 select * from order where status!=0 and stauts!=1 not in/not exists都不...

mskk
19分钟前
4
0
IntelliJ IDEA (Mac) 运行速度优化(JVM+localhost)

1.1. JVM 参数配置 打开 idea,菜单 –> help –> edit custom vm options,调整参数,重启即可。 具体调整参数: -Xms2g -Xmx2g -XX:ReservedCodeCacheSize=1024m -XX:+UseCompressedOops 1......

指尖Coding
28分钟前
6
0

没有更多内容

加载失败,请刷新页面

加载更多

返回顶部
顶部