七大洲+世界主要国家城市三级联动mysql、json版本

CREATE TABLE [country]( [id] [int] IDENTITY(1,1) NOT NULL, [parentId] [int] NOT NULL CONSTRAINT [DF_country_parentId] DEFAULT ((0)), [cname] [nvarchar](50) NULL, [ename] [nvarchar](50) NULL, CONSTRAINT [PK_country] PRIMARY KEY CLUSTERED ( [id] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY]; insert into country (parentId,cname,ename) values (0,'中国',''); insert into country (parentId,cname,ename) values (0,'韩国',''); insert into country (parentId,cname,ename) values (0,'日本',''); insert into country (parentId,cname,ename) values (0,'新加坡',''); insert into country (parentId,cname,ename) values (0,'马来西亚',''); insert into country (parentId,cname,ename) values (0,'菲律宾',''); insert into country (parentId,cname,ename) values (0,'沙特阿拉伯',''); insert into country (parentId,cname,ename) values (0,'朝鲜',''); insert into country (parentId,cname,ename) values (0,'越南',''); insert into country (parentId,cname,ename) values (0,'缅甸',''); insert into country (parentId,cname,ename) values (0,'德国',''); insert into country (parentId,cname,ename) values (0,'英国',''); insert into country (parentId,cname,ename) values (0,'法国',''); insert into country (parentId,cname,ename) values (0,'爱尔兰',''); insert into country (parentId,cname,ename) values (0,'波兰',''); insert into country (parentId,cname,ename) values (0,'西班牙',''); insert into country (parentId,cname,ename) values (0,'意大利',''); insert into country (parentId,cname,ename) values (0,'俄罗斯',''); insert into country (parentId,cname,ename) values (0,'荷兰',''); insert into country (parentId,cname,ename) values (0,'美国',''); insert into country (parentId,cname,ename) values (0,'加拿大',''); insert into country (parentId,cname,ename) values (0,'巴西',''); insert into country (parentId,cname,ename) values (0,'阿根廷',''); insert into country (parentId,cname,ename) values (0,'新西兰',''); insert into country (parentId,cname,ename) values (0,'澳大利亚',''); insert into country (parentId,cname,ename) values (0,'印度',''); insert into country (parentId,cname,ename) values (0,'埃及',''); insert into country (parentId,cname,ename) values (1,'安徽',''); insert into country (parentId,cname,ename) values (1,'北京',''); insert into country (parentId,cname,ename) values (1,'福建',''); insert into country (parentId,cname,ename) values (1,'甘肃',''); insert into country (parentId,cname,ename) values (1,'广东',''); insert into country (parentId,cname,ename) values (1,'广西',''); insert into country (parentId,cname,ename) values (1,'贵州',''); insert into country (parentId,cname,ename) values (1,'海南',''); insert into country (parentId,cname,ename) values (1,'河北',''); insert into country (parentId,cname,ename) values (1,'河南',''); insert into country (parentId,cname,ename) values (1,'黑龙江',''); insert into country (parentId,cname,ename) values (1,'湖北',''); insert into country (parentId,cname,ename) values (1,'湖南',''); insert into country (parentId,cname,ename) values (1,'吉林',''); insert into country (parentId,cname,ename) values (1,'江苏',''); insert into country (parentId,cname,ename) values (1,'江西',''); insert into country (parentId,cname,ename) values (1,'辽宁',''); insert into country (parentId,cname,ename) values (1,'内蒙古',''); insert into country (parentId,cname,ename) values (1,'宁夏',''); insert into country (parentId,cname,ename) values (1,'青海',''); insert into country (parentId,cname,ename) values (1,'山东',''); insert into country (parentId,cname,ename) values (1,'山西',''); insert into country (parentId,cname,ename) values (1,'陕西',''); insert into country (parentId,cname,ename) values (1,'上海',''); insert into country (parentId,cname,ename) values (1,'四川',''); insert into country (parentId,cname,ename) values (1,'天津',''); insert into country (parentId,cname,ename) values (1,'西藏',''); insert into country (parentId,cname,ename) values (1,'新疆',''); insert into country (parentId,cname,ename) values (1,'云南',''); insert into country (parentId,cname,ename) values (1,'浙江',''); insert into country (parentId,cname,ename) values (1,'重庆',''); insert into country (parentId,cname,ename) values (2,'汉城特別市',''); insert into country (parentId,cname,ename) values (2,'釜山广域市',''); insert into country (parentId,cname,ename) values (2,'大邱广域市',''); insert into country (parentId,cname,ename) values (2,'仁川广域市',''); insert into country (parentId,cname,ename) values (2,'光州广域市',''); insert into country (parentId,cname,ename) values (2,'大田广域市',''); insert into country (parentId,cname,ename) values (2,'蔚山广域市',''); insert into country (parentId,cname,ename) values (2,'京畿道',''); insert into country (parentId,cname,ename) values (2,'江原道',''); insert into country (parentId,cname,ename) values (2,'忠清北道',''); insert into country (parentId,cname,ename) values (2,'忠清南道',''); insert into country (parentId,cname,ename) values (2,'全罗北道',''); insert into country (parentId,cname,ename) values (2,'全罗南道',''); insert into country (parentId,cname,ename) values (2,'庆尚北道',''); insert into country (parentId,cname,ename) values (2,'庆尚南道',''); insert into country (parentId,cname,ename) values (2,'济州道',''); insert into country (parentId,cname,ename) values (3,'东京都',''); insert into country (parentId,cname,ename) values (3,'神奈川县',''); insert into country (parentId,cname,ename) values (3,'大阪府',''); insert into country (parentId,cname,ename) values (3,'爱知县',''); insert into country (parentId,cname,ename) values (3,'北海道',''); insert into country (parentId,cname,ename) values (3,'兵库县',''); insert into country (parentId,cname,ename) values (3,'京都府',''); insert into country (parentId,cname,ename) values (3,'福冈县',''); insert into country (parentId,cname,ename) values (3,'神奈川县',''); insert into country (parentId,cname,ename) values (3,'埼玉县',''); insert into country (parentId,cname,ename) values (3,'广岛县',''); insert into country (parentId,cname,ename) values (3,'宫城县',''); insert into country (parentId,cname,ename) values (3,'福冈县',''); insert into country (parentId,cname,ename) values (3,'千叶县',''); insert into country (parentId,cname,ename) values (4,'新加坡',''); insert into country (parentId,cname,ename) values (5,'吉打','Kedah'); insert into country (parentId,cname,ename) values (5,'槟榔屿','Pulau Pinang'); insert into country (parentId,cname,ename) values (5,'霹雳','Perak'); insert into country (parentId,cname,ename) values (5,'吉兰丹','Kelantan'); insert into country (parentId,cname,ename) values (5,'丁加奴','Terengganu'); insert into country (parentId,cname,ename) values (5,'彭亨','Pahang'); insert into country (parentId,cname,ename) values (5,'雪兰莪','Selangor'); insert into country (parentId,cname,ename) values (5,'吉隆坡联邦直辖区','Kuala Lumpur'); insert into country (parentId,cname,ename) values (5,'布特拉再也联邦直辖区','Putrajaya'); insert into country (parentId,cname,ename) values (5,'森美兰','Sembilan'); insert into country (parentId,cname,ename) values (5,'马六甲','Melaka'); insert into country (parentId,cname,ename) values (5,'柔佛','Johor'); insert into country (parentId,cname,ename) values (5,'斗湖省','Tawau'); insert into country (parentId,cname,ename) values (5,'山打根省','Sandakan'); insert into country (parentId,cname,ename) values (5,'西海岸省','Pantai Barat'); insert into country (parentId,cname,ename) values (6,'伊罗戈斯','Ilocos'); insert into country