最新的全国省市区数据整理

qq_39339768
已于 2023-09-13 14:42:33 修改
阅读量243
点赞数
文章标签：数据库前端
于 2023-09-13 14:39:47 首次发布
本文链接：https://blog.csdn.net/qq_39339768/article/details/132853348
版权
INSERT INTO `w_province`(`id`, `province_id`, `province`, `py`, `py_head`, `country_id`) VALUES (1, '110000', '北京', 'beijing', 'bj', 1);
INSERT INTO `w_province`(`id`, `province_id`, `province`, `py`, `py_head`, `country_id`) VALUES (2, '120000', '天津市', 'tianjinshi', 'tjs', 1);
INSERT INTO `w_province`(`id`, `province_id`, `province`, `py`, `py_head`, `country_id`) VALUES (3, '130000', '河北省', 'hebeisheng', 'hbs', 1);
INSERT INTO `w_province`(`id`, `province_id`, `province`, `py`, `py_head`, `country_id`) VALUES (4, '140000', '山西省', 'shanxisheng', 'sxs', 1);
INSERT INTO `w_province`(`id`, `province_id`, `province`, `py`, `py_head`, `country_id`) VALUES (5, '150000', '内蒙古自治区', 'neimengguzizhiqu', 'nmgzzq', 1);
INSERT INTO `w_province`(`id`, `province_id`, `province`, `py`, `py_head`, `country_id`) VALUES (6, '210000', '辽宁省', 'liaoningsheng', 'lns', 1);
INSERT INTO `w_province`(`id`, `province_id`, `province`, `py`, `py_head`, `country_id`) VALUES (7, '220000', '吉林省', 'jilinsheng', 'jls', 1);
INSERT INTO `w_province`(`id`, `province_id`, `province`, `py`, `py_head`, `country_id`) VALUES (8, '230000', '黑龙江省', 'heilongjiangsheng', 'hljs', 1);
INSERT INTO `w_province`(`id`, `province_id`, `province`, `py`, `py_head`, `country_id`) VALUES (9, '310000', '上海', 'shanghai', 'sh', 1);
INSERT INTO `w_province`(`id`, `province_id`, `province`, `py`, `py_head`, `country_id`) VALUES (10, '320000', '江苏省', 'jiangsusheng', 'jss', 1);
INSERT INTO `w_province`(`id`, `province_id`, `province`, `py`, `py_head`, `country_id`) VALUES (11, '330000', '浙江省', 'zhejiangsheng', 'zjs', 1);
INSERT INTO `w_province`(`id`, `province_id`, `province`, `py`, `py_head`, `country_id`) VALUES (12, '340000', '安徽省', 'anhuisheng', 'ahs', 1);
INSERT INTO `w_province`(`id`, `province_id`, `province`, `py`, `py_head`, `country_id`) VALUES (13, '350000', '福建省', 'fujiansheng', 'fjs', 1);
INSERT INTO `w_province`(`id`, `province_id`, `province`, `py`, `py_head`, `country_id`) VALUES (14, '360000', '江西省', 'jiangxisheng', 'jxs', 1);
INSERT INTO `w_province`(`id`, `province_id`, `province`, `py`, `py_head`, `country_id`) VALUES (15, '370000', '山东省', 'shandongsheng', 'sds', 1);
INSERT INTO `w_province`(`id`, `province_id`, `province`, `py`, `py_head`, `country_id`) VALUES (16, '410000', '河南省', 'henansheng', 'hns', 1);
INSERT INTO `w_province`(`id`, `province_id`, `province`, `py`, `py_head`, `country_id`) VALUES (17, '420000', '湖北省', 'hubeisheng', 'hbs', 1);
INSERT INTO `w_province`(`id`, `province_id`, `province`, `py`, `py_head`, `country_id`) VALUES (18, '430000', '湖南省', 'hunansheng', 'hns', 1);
INSERT INTO `w_province`(`id`, `province_id`, `province`, `py`, `py_head`, `country_id`) VALUES (19, '440000', '广东省', 'guangdongsheng', 'gds', 1);
INSERT INTO `w_province`(`id`, `province_id`, `province`, `py`, `py_head`, `country_id`) VALUES (20, '450000', '广西壮族自治区', 'guangxizhuangzuzizhiqu', 'gxzzzzq', 1);
INSERT INTO `w_province`(`id`, `province_id`, `province`, `py`, `py_head`, `country_id`) VALUES (21, '460000', '海南省', 'hainansheng', 'hns', 1);
INSERT INTO `w_province`(`id`, `province_id`, `province`, `py`, `py_head`, `country_id`) VALUES (22, '500000', '重庆市', 'chongqingshi', 'cqs', 1);
INSERT INTO `w_province`(`id`, `province_id`, `province`, `py`, `py_head`, `country_id`) VALUES (23, '510000', '四川省', 'sichuansheng', 'scs', 1);
INSERT INTO `w_province`(`id`, `province_id`, `province`, `py`, `py_head`, `country_id`) VALUES (24, '520000', '贵州省', 'guizhousheng', 'gzs', 1);
INSERT INTO `w_province`(`id`, `province_id`, `province`, `py`, `py_head`, `country_id`) VALUES (25, '530000', '云南省', 'yunnansheng', 'yns', 1);
INSERT INTO `w_province`(`id`, `province_id`, `province`, `py`, `py_head`, `country_id`) VALUES (26, '540000', '西藏自治区', 'xizangzizhiqu', 'xzzzq', 1);
INSERT INTO `w_province`(`id`, `province_id`, `province`, `py`, `py_head`, `country_id`) VALUES (27, '610000', '陕西省', 'shanxisheng', 'sxs', 1);
INSERT INTO `w_province`(`id`, `province_id`, `province`, `py`, `py_head`, `country_id`) VALUES (28, '620000', '甘肃省', 'gansusheng', 'gss', 1);
INSERT INTO `w_province`(`id`, `province_id`, `province`, `py`, `py_head`, `country_id`) VALUES (29, '630000', '青海省', 'qinghaisheng', 'qhs', 1);
INSERT INTO `w_province`(`id`, `province_id`, `province`, `py`, `py_head`, `country_id`) VALUES (30, '640000', '宁夏回族自治区', 'ningxiahuizuzizhiqu', 'nxhzzzq', 1);
INSERT INTO `w_province`(`id`, `province_id`, `province`, `py`, `py_head`, `country_id`) VALUES (31, '650000', '新疆维吾尔自治区', 'xinjiangweiwuerzizhiqu', 'xjwwezzq', 1);
INSERT INTO `w_province`(`id`, `province_id`, `province`, `py`, `py_head`, `country_id`) VALUES (32, '710000', '台湾省', 'taiwansheng', 'tws', 1);
INSERT INTO `w_province`(`id`, `province_id`, `province`, `py`, `py_head`, `country_id`) VALUES (33, '810000', '香港特别行政区', 'xianggangtebiexingzhengqu', 'xgtbxzq', 1);
INSERT INTO `w_province`(`id`, `province_id`, `province`, `py`, `py_head`, `country_id`) VALUES (34, '820000', '澳门特别行政区', 'aomentebiexingzhengqu', 'amtbxzq', 1);