中国省市SQL表---省级行政单位表

中国34个省级行政单位 23个省 5个自治区 4个直辖市 2特别行政区

-- 省级行政单位

INSERT INTO `ckcx_sysinfo`.`_ud_province_city` ( `RUID`, `createtime`, `jbruid`, `parentid`, `name`, `siteid`, `customercode` )
VALUES( 'province1', now( ), 'province_city', 'chinese', '北京市', 'ckcx', 1 );
INSERT INTO `ckcx_sysinfo`.`_ud_province_city` ( `RUID`, `createtime`, `jbruid`, `parentid`, `name`, `siteid`, `customercode` )
VALUES( 'province2', now( ), 'province_city', 'chinese', '天津市', 'ckcx', 1 );
INSERT INTO `ckcx_sysinfo`.`_ud_province_city` ( `RUID`, `createtime`, `jbruid`, `parentid`, `name`, `siteid`, `customercode` )
VALUES( 'province3', now( ), 'province_city', 'chinese', '上海市', 'ckcx', 1 );
INSERT INTO `ckcx_sysinfo`.`_ud_province_city` ( `RUID`, `createtime`, `jbruid`, `parentid`, `name`, `siteid`, `customercode` )
VALUES( 'province4', now( ), 'province_city', 'chinese', '重庆市', 'ckcx', 1 );
INSERT INTO `ckcx_sysinfo`.`_ud_province_city` ( `RUID`, `createtime`, `jbruid`, `parentid`, `name`, `siteid`, `customercode` )
VALUES( 'province5', now( ), 'province_city', 'chinese', '河北省', 'ckcx', 1 );
INSERT INTO `ckcx_sysinfo`.`_ud_province_city` ( `RUID`, `createtime`, `jbruid`, `parentid`, `name`, `siteid`, `customercode` )
VALUES( 'province6', now( ), 'province_city', 'chinese', '山西省', 'ckcx', 1 );
INSERT INTO `ckcx_sysinfo`.`_ud_province_city` ( `RUID`, `createtime`, `jbruid`, `parentid`, `name`, `siteid`, `customercode` )
VALUES( 'province7', now( ), 'province_city', 'chinese', '台湾省', 'ckcx', 1 );
INSERT INTO `ckcx_sysinfo`.`_ud_province_city` ( `RUID`, `createtime`, `jbruid`, `parentid`, `name`, `siteid`, `customercode` )
VALUES( 'province8', now( ), 'province_city', 'chinese', '辽宁省', 'ckcx', 1 );
INSERT INTO `ckcx_sysinfo`.`_ud_province_city` ( `RUID`, `createtime`, `jbruid`, `parentid`, `name`, `siteid`, `customercode` )
VALUES( 'province9', now( ), 'province_city', 'chinese', '吉林省', 'ckcx', 1 );
INSERT INTO `ckcx_sysinfo`.`_ud_province_city` ( `RUID`, `createtime`, `jbruid`, `parentid`, `name`, `siteid`, `customercode` )
VALUES( 'province10', now( ), 'province_city', 'chinese', '黑龙江省', 'ckcx', 1 );
INSERT INTO `ckcx_sysinfo`.`_ud_province_city` ( `RUID`, `createtime`, `jbruid`, `parentid`, `name`, `siteid`, `customercode` )
VALUES( 'province11', now( ), 'province_city', 'chinese', '江苏省', 'ckcx', 1 );
INSERT INTO `ckcx_sysinfo`.`_ud_province_city` ( `RUID`, `createtime`, `jbruid`, `parentid`, `name`, `siteid`, `customercode` )
VALUES( 'province12', now( ), 'province_city', 'chinese', '浙江省', 'ckcx', 1 );
INSERT INTO `ckcx_sysinfo`.`_ud_province_city` ( `RUID`, `createtime`, `jbruid`, `parentid`, `name`, `siteid`, `customercode` )
VALUES( 'province13', now( ), 'province_city', 'chinese', '安徽省', 'ckcx', 1 );
INSERT INTO `ckcx_sysinfo`.`_ud_province_city` ( `RUID`, `createtime`, `jbruid`, `parentid`, `name`, `siteid`, `customercode` )
VALUES( 'province14', now( ), 'province_city', 'chinese', '福建省', 'ckcx', 1 );
INSERT INTO `ckcx_sysinfo`.`_ud_province_city` ( `RUID`, `createtime`, `jbruid`, `parentid`, `name`, `siteid`, `customercode` )
VALUES( 'province15', now( ), 'province_city', 'chinese', '江西省', 'ckcx', 1 );
INSERT INTO `ckcx_sysinfo`.`_ud_province_city` ( `RUID`, `createtime`, `jbruid`, `parentid`, `name`, `siteid`, `customercode` )
VALUES( 'province16', now( ), 'province_city', 'chinese', '山东省', 'ckcx', 1 );
INSERT INTO `ckcx_sysinfo`.`_ud_province_city` ( `RUID`, `createtime`, `jbruid`, `parentid`, `name`, `siteid`, `customercode` )
VALUES( 'province17', now( ), 'province_city', 'chinese', '河南省', 'ckcx', 1 );
INSERT INTO `ckcx_sysinfo`.`_ud_province_city` ( `RUID`, `createtime`, `jbruid`, `parentid`, `name`, `siteid`, `customercode` )
VALUES( 'province18', now( ), 'province_city', 'chinese', '湖北省', 'ckcx', 1 );
INSERT INTO `ckcx_sysinfo`.`_ud_province_city` ( `RUID`, `createtime`, `jbruid`, `parentid`, `name`, `siteid`, `customercode` )
VALUES( 'province19', now( ), 'province_city', 'chinese', '湖南省', 'ckcx', 1 );
INSERT INTO `ckcx_sysinfo`.`_ud_province_city` ( `RUID`, `createtime`, `jbruid`, `parentid`, `name`, `siteid`, `customercode` )
VALUES( 'province20', now( ), 'province_city', 'chinese', '广东省', 'ckcx', 1 );
INSERT INTO `ckcx_sysinfo`.`_ud_province_city` ( `RUID`, `createtime`, `jbruid`, `parentid`, `name`, `siteid`, `customercode` )
VALUES( 'province21', now( ), 'province_city', 'chinese', '甘肃省', 'ckcx', 1 );
INSERT INTO `ckcx_sysinfo`.`_ud_province_city` ( `RUID`, `createtime`, `jbruid`, `parentid`, `name`, `siteid`, `customercode` )
VALUES( 'province22', now( ), 'province_city', 'chinese', '四川省', 'ckcx', 1 );
INSERT INTO `ckcx_sysinfo`.`_ud_province_city` ( `RUID`, `createtime`, `jbruid`, `parentid`, `name`, `siteid`, `customercode` )
VALUES( 'province23', now( ), 'province_city', 'chinese', '贵州省', 'ckcx', 1 );
INSERT INTO `ckcx_sysinfo`.`_ud_province_city` ( `RUID`, `createtime`, `jbruid`, `parentid`, `name`, `siteid`, `customercode` )
VALUES( 'province24', now( ), 'province_city', 'chinese', '海南省', 'ckcx', 1 );
INSERT INTO `ckcx_sysinfo`.`_ud_province_city` ( `RUID`, `createtime`, `jbruid`, `parentid`, `name`, `siteid`, `customercode` )
VALUES( 'province25', now( ), 'province_city', 'chinese', '云南省', 'ckcx', 1 );
INSERT INTO `ckcx_sysinfo`.`_ud_province_city` ( `RUID`, `createtime`, `jbruid`, `parentid`, `name`, `siteid`, `customercode` )
VALUES( 'province26', now( ), 'province_city', 'chinese', '青海省', 'ckcx', 1 );
INSERT INTO `ckcx_sysinfo`.`_ud_province_city` ( `RUID`, `createtime`, `jbruid`, `parentid`, `name`, `siteid`, `customercode` )
VALUES( 'province27', now( ), 'province_city', 'chinese', '陕西省', 'ckcx', 1 );
INSERT INTO `ckcx_sysinfo`.`_ud_province_city` ( `RUID`, `createtime`, `jbruid`, `parentid`, `name`, `siteid`, `customercode` )
VALUES( 'province28', now( ), 'province_city', 'chinese', '广西壮族自治区', 'ckcx', 1 );
INSERT INTO `ckcx_sysinfo`.`_ud_province_city` ( `RUID`, `createtime`, `jbruid`, `parentid`, `name`, `siteid`, `customercode` )
VALUES( 'province29', now( ), 'province_city', 'chinese', '西藏自治区', 'ckcx', 1 );
INSERT INTO `ckcx_sysinfo`.`_ud_province_city` ( `RUID`, `createtime`, `jbruid`, `parentid`, `name`, `siteid`, `customercode` )
VALUES( 'province30', now( ), 'province_city', 'chinese', '宁夏回族自治区', 'ckcx', 1 );
INSERT INTO `ckcx_sysinfo`.`_ud_province_city` ( `RUID`, `createtime`, `jbruid`, `parentid`, `name`, `siteid`, `customercode` )
VALUES( 'province31', now( ), 'province_city', 'chinese', '新疆维吾尔自治区', 'ckcx', 1 );
INSERT INTO `ckcx_sysinfo`.`_ud_province_city` ( `RUID`, `createtime`, `jbruid`, `parentid`, `name`, `siteid`, `customercode` )
VALUES( 'province32', now( ), 'province_city', 'chinese', '内蒙古自治区', 'ckcx', 1 );
INSERT INTO `ckcx_sysinfo`.`_ud_province_city` ( `RUID`, `createtime`, `jbruid`, `parentid`, `name`, `siteid`, `customercode` )
VALUES( 'province33', now( ), 'province_city', 'chinese', '澳门特别行政区', 'ckcx', 1 );
INSERT INTO `ckcx_sysinfo`.`_ud_province_city` ( `RUID`, `createtime`, `jbruid`, `parentid`, `name`, `siteid`, `customercode` )
VALUES( 'province34', now( ), 'province_city', 'chinese', '香港特别行政区', 'ckcx', 1 );