SQL: Cikakken Suna na Neman Jihohi da Larduna na Amurka da Kanada

Amirka ta Arewa

Yayin aiki a kan Taswirar Taswirar Google a ƙarshen wannan satin, ina buƙatar yin tebur a ciki MySQL wannan ya fassara ƙasar lambobi 2 da kuma taƙaitawar jihohi zuwa cikakken suna. Na tabbata wannan wani abu ne da ake buƙata kaɗan, don haka na sanya fayil ɗin SQL a kan sabina don saukarwa.

Ga bayanin SQL na gajerun Yanki da Larduna na Amurka da Kanada. Na kuma kara Fihirisar kan kasar da rashin idda na jihar don inganta ayyuka.

CREATE TABLE `` (`` COUNTRYID` varchar (2) BA NULL bane, '' STATEID` varchar (2) BA NULL, `` FULLNAME` varchar (30) BA NULL, KEY 'country` (' COUNTRYID`), KEY ʻid` (`` STATEID`)) ENGINE = MyISAM DEFAULT CHARSET = utf8 COMMENT = 'Jiha da Lardin Cikakken Suna na Neman Amurka da Kanada';
Saka cikin `` ('' COUNTRYID`, `` STATEID`, '' FULLNAME`) VALUES ('CA', 'AB', 'Alberta'), ('CA', 'BC', 'British Columbia'), (' CA ',' MB ',' Manitoba '), (' CA ',' NB ',' New Brunswick '), (' CA ',' NL ',' Newfoundland and Labrador '), (' CA ',' NS ',' Nova Scotia '), (' CA ',' NT ',' Yankin Arewa Maso Yamma '), (' CA ',' NU ',' Nunavut '), (' CA ',' ON ',' Ontario ') , ('CA', 'PE', 'Prince Edward Island'), ('CA', 'QC', 'Quebec'), ('CA', 'SK', 'Saskatachewan'), ('CA', 'YT', 'Yukon'), ('US', 'AK', 'Alaska'), ('US', 'AL', 'Alabama'), ('US', 'AR', 'Arkansas') , ('US', 'AZ', 'Arizona'), ('US', 'CA', 'California'), ('US', 'CO', 'Colorado'), ('US', 'CT ',' Connecticut '), (' US ',' DC ',' District of Columbia '), (' US ',' DE ',' Delaware '), (' US ',' FL ',' Florida ') , ('US', 'GA', 'Georgia'), ('US', 'HI', 'Hawaii'), ('US', 'IA', 'Iowa'), ('US', 'ID ',' Idaho '), (' US ',' IL ',' Illinois '), (' US ',' IN ',' Indiana '), (' US ',' KS ',' Kansas '), ( 'US', 'KY', 'Kentucky'), ('US', 'LA', 'Louisiana'), ('US', 'MA', 'Massachusetts'), ('US', 'MD', 'Mar yland '), (' US ',' ME ',' Maine '), (' US ',' MI ',' Michigan '), (' US ',' MN ',' Minnesota '), (' US ' , 'MO', 'Missouri'), ('US', 'MS', 'Mississippi'), ('US', 'MT', 'Montana'), ('US', 'NC', 'North Carolina' '), (' US ',' ND ',' North Dakota '), (' US ',' NE ',' Nebraska '), (' US ',' NH ',' New Hampshire '), (' US ',' NJ ',' New Jersey '), (' US ',' NM ',' New Mexico '), (' US ',' NV ',' Nevada '), (' US ',' NY ', 'New York'), ('US', 'OH', 'Ohio'), ('US', 'OK', 'Oklahoma'), ('US', 'OR', 'Oregon'), (' US ',' PA ',' Pennsylvania '), (' US ',' RI ',' Rhode Island '), (' US ',' SC ',' South Carolina '), (' US ',' SD ' , 'South Dakota'), ('US', 'TN', 'Tennessee'), ('US', 'TX', 'Texas'), ('US', 'UT', 'Utah'), ( 'US', 'VA', 'Virginia'), ('US', 'VI', 'Virgin Islands'), ('US', 'VT', 'Vermont'), ('US', 'WA' , 'Washington'), ('US', 'WI', 'Wisconsin'), ('US', 'WV', 'West Virginia'), ('US', 'WY', 'Wyoming');

Hat hat zuwa Brian wanda yake da CSV mai kyau Na sami damar yin aiki daga.

Me kuke tunani?

Wannan shafin yana amfani da Akismet don rage spam. Koyi yadda aka sarrafa bayanan bayaninka.