SQL: Ho Batla Mabitso ka botlalo bakeng sa Linaha le liprofinse bakeng sa US le Canada

amerika e leboea

Ha ke ntse ke sebetsa morerong oa 'Mapa oa Google bekeng ena, ke ile ka hloka ho etsa tafole ka MySQL e fetoletseng likhutsufatso tsa naha le linaha tse peli ho lebitso le felletseng. Kea kholoa hore sena ke ntho e hlokahalang hanyane, ka hona ke behile file ea SQL ho seva ea ka hore e e jarolle.

Mona ke polelo ea SQL bakeng sa Likhutsufatso tsa Naha le Puso bakeng sa United States le Canada. Ke boetse ke kentse Index ho li-ID tsa naha le tsa mmuso ho ntlafatsa ts'ebetso.

BOPA LITABLE `e bolela` (` COUNTRYID` varchar (2) NOT NULL, `STATEID` varchar (2) NOT NULL,` FULLNAME` varchar (30) NOT NULL, KEY` country` (`COUNTRYID`), KEY```` (`STATEID`)) ENGINE = MyISAM DEFAULT CHARSET = utf8 COMMENT = 'Ho Batla Lebitso la Naha le la Puso bakeng sa US le Canada';
Kenya INO `` e bolela` (`COUNTRYID`,` STATEID`, `FULLNAME`) BOTSOALLE ('CA', 'AB', 'Alberta'), ('CA', 'BC', 'British Columbia'), (' CA ',' MB ',' Manitoba '), (' CA ',' NB ',' New Brunswick '), (' CA ',' NL ',' Newfoundland le Labrador '), (' 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 ',' Setereke sa 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', 'Hlakubele 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', 'Lihlekehleke tsa Virgin'), ('US', 'VT', 'Vermont'), ('US', 'WA' , 'Washington'), ('US', 'WI', 'Wisconsin'), ('US', 'WV', 'West Virginia'), ('US', 'WY', 'Wyoming');

Hat tip ho Brian ea neng a e-na le CSV e ntle Ke khonne ho sebetsa ho tloha.

U nahana eng?

Sebaka sena se sebelisa Akismet ho fokotsa spam. Ithute kamoo litlhaloso tsa hau li hlahang kateng.