sql全国省市联动级联

大家讲道理

发布时间：2016-11-10 11:39:41

1416人浏览过

来源于php中文网

原创

/*添加省份表数据*/
INSERT INTO Province(Pcode,Pname,NationCode) VALUES(110000,'北京市',100000)
INSERT INTO Province(Pcode,Pname,NationCode) VALUES(120000,'天津市',100000)
INSERT INTO Province(Pcode,Pname,NationCode) VALUES(130000,'河北省',100000)
INSERT INTO Province(Pcode,Pname,NationCode) VALUES(140000,'山西省',100000)
INSERT INTO Province(Pcode,Pname,NationCode) VALUES(150000,'内蒙古自治区',100000)
INSERT INTO Province(Pcode,Pname,NationCode) VALUES(210000,'辽宁省',100000)
INSERT INTO Province(Pcode,Pname,NationCode) VALUES(220000,'吉林省',100000)
INSERT INTO Province(Pcode,Pname,NationCode) VALUES(230000,'黑龙江',100000)
INSERT INTO Province(Pcode,Pname,NationCode) VALUES(310000,'上海市',100000)
INSERT INTO Province(Pcode,Pname,NationCode) VALUES(320000,'江苏省',100000)
INSERT INTO Province(Pcode,Pname,NationCode) VALUES(330000,'浙江省',100000)
INSERT INTO Province(Pcode,Pname,NationCode) VALUES(340000,'安徽省',100000)
INSERT INTO Province(Pcode,Pname,NationCode) VALUES(350000,'福建省',100000)
INSERT INTO Province(Pcode,Pname,NationCode) VALUES(360000,'江西省',100000)
INSERT INTO Province(Pcode,Pname,NationCode) VALUES(370000,'山东省',100000)
INSERT INTO Province(Pcode,Pname,NationCode) VALUES(410000,'河南省',100000)
INSERT INTO Province(Pcode,Pname,NationCode) VALUES(420000,'湖北省',100000)
INSERT INTO Province(Pcode,Pname,NationCode) VALUES(430000,'湖南省',100000)
INSERT INTO Province(Pcode,Pname,NationCode) VALUES(440000,'广东省',100000)
INSERT INTO Province(Pcode,Pname,NationCode) VALUES(450000,'广西壮族自治区',100000)
INSERT INTO Province(Pcode,Pname,NationCode) VALUES(460000,'海南省',100000)
INSERT INTO Province(Pcode,Pname,NationCode) VALUES(500000,'重庆市',100000)
INSERT INTO Province(Pcode,Pname,NationCode) VALUES(510000,'四川省',100000)
INSERT INTO Province(Pcode,Pname,NationCode) VALUES(520000,'贵州省',100000)
INSERT INTO Province(Pcode,Pname,NationCode) VALUES(530000,'云南省',100000)
INSERT INTO Province(Pcode,Pname,NationCode) VALUES(540000,'西藏自治区',100000)
INSERT INTO Province(Pcode,Pname,NationCode) VALUES(610000,'陕西省',100000)
INSERT INTO Province(Pcode,Pname,NationCode) VALUES(620000,'甘肃省',100000)
INSERT INTO Province(Pcode,Pname,NationCode) VALUES(630000,'青海省',100000)
INSERT INTO Province(Pcode,Pname,NationCode) VALUES(640000,'宁夏回族自治区',100000)
INSERT INTO Province(Pcode,Pname,NationCode) VALUES(650000,'新疆维吾尔自治区',100000)
INSERT INTO Province(Pcode,Pname,NationCode) VALUES(710000,'台湾省',100000)
INSERT INTO Province(Pcode,Pname,NationCode) VALUES(810000,'香港特别行政区',100000)
INSERT INTO Province(Pcode,Pname,NationCode) VALUES(820000,'澳门特别行政区',100000)

MySQL怎么查看版本号_查询MySQL数据库版本命令

如何减少回表查询_mysql索引访问优化

mysql中子查询如何书写_mysql 子查询教程

如何优化in查询_mysql条件查询性能

mysql中触发器在数据库设计中的应用实践

本站声明：本文内容由网友自发贡献，版权归原作者所有，本站不承担相应法律责任。如您发现有涉嫌抄袭侵权的内容，请联系admin@php.cn

上一篇：找到活动的SQL连接，并杀掉它！下一篇：MySQL常用基本操作

作者最新文章

2017招聘季：PHP面试题超强总结！

2018-05-11 13:50

BOM、DOM与JS中的事件

2018-05-17 15:58