SQL: Yakazara Zita Kutsvaga kweZviitiko neMatunhu eUS neCanada

north america

Ndichiri kushanda pane Google Mapping chirongwa vhiki ino, ini ndaida kugadzira tafura mu MySQL iyo yakashandura nyika ine manhamba maviri uye nyika zvipfupiso kuzita rakazara Ndine chokwadi chekuti ichi chinhu chinodiwa zvishoma, saka ndaisa iyo SQL faira kumusoro kwangu server kurodha pasi.

Hechino chirevo cheQLC cheHurumende nePurovhinzi Mipfupiso yeUnited States neCanada. Ini ndawedzerawo Index kune ese ari maviri nyika uye nyika maid kuvandudza mashandiro.

GADZIRA TABLE `inoti` (` COUNTRYID` varchar (2) HAPANA, `STATEID` varchar (2) HAPANA,` FULLNAME` varchar (30) HAPANA, CHINOKOSHA `nyika` (` COUNTRYID`), KEY ʻid` (`STATEID`)) ENGINE = MyISAM DEFAULT CHARSET = utf8 COMMENT = 'Nyika nePurovhinzi Yakazara Mazita Ekutsvaga kuUS neCanada';
INSERT TO IN `` states` (`COUNTRYID`,` STATEID`, `FULLNAME`) VALUES ('CA', 'AB', 'Alberta'), ('CA', 'BC', 'British Columbia'), (' CA ',' MB ',' Manitoba '), (' CA ',' NB ',' New Brunswick '), (' CA ',' NL ',' Newfoundland neLabrador '), (' CA ',' NS ',' Nova Scotia '), (' CA ',' NT ',' Northwest Territories '), (' 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 ',' Dunhu reColumbia '), (' 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', 'Kurume ('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 muromo kune Brian uyo aive neCSV yakanaka Ini ndakakwanisa kushanda kubva.

Unofungei?

Nzvimbo iyi inoshandisa Akismet kuderedza spam. Dzidza kuti sei deta yako inoshandiswa.