SQL: Kufufuza Kwathunthu kwa Maiko ndi Maiko ku US ndi Canada

kumpoto kwa Amerika

Ndikugwira ntchito ya Mapu a Google kumapeto kwa sabata ino, ndimayenera kupanga tebulo MySQL yomwe idamasulira mayiko ndi manambala achidule achidule. Ndikutsimikiza kuti ichi ndichinthu chomwe chimafunikira pang'ono, chifukwa chake ndaika fayilo ya SQL pa seva yanga kuti itsitsidwe.

Nayi ndemanga ya SQL Yamasulira Amaboma ndi Zigawo ku United States ndi Canada. Ndawonjezeranso Index pama ID ndi mayiko onse kuti ndikwaniritse magwiridwe antchito.

Pangani TABLE `states` (` COUNTRYID` varchar (2) NOT NULL, `STATEID` varchar (2) NOT NULL,` FULLNAME` varchar (30) NOT NULL, KEY `country` (` COUNTRYID`), KEY `id` (`STATEID`)) ENGINE = MyISAM DEFAULT CHARSET = utf8 COMMENT = 'Boma ndi Chigawo Chofunafuna Dzina Lonse ku US ndi Canada';
INSERT INTO `akuti` (` COUNTRYID`, `STATEID`, 'FULLNAME`) ZOTHANDIZA (' CA ',' AB ',' Alberta '), (' CA ',' BC ',' British Columbia '), (' CA ',' MB ',' Manitoba '), (' CA ',' NB ',' New Brunswick '), (' CA ',' NL ',' Newfoundland ndi 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 ',' 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 ('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', 'Islands Islands'), ('US', 'VT', 'Vermont'), ('US', 'WA') , 'Washington'), ('US', 'WI', 'Wisconsin'), ('US', 'WV', 'West Virginia'), ('US', 'WY', 'Wyoming');

Chipewa ku Brian yemwe anali ndi CSV yabwino Ndinatha kugwira ntchito kuchokera.