I-SQL: Ukubheka Igama Okugcwele KweZifundazwe Nezifundazwe ze-US neCanada

i-America esenyakatho

Ngenkathi ngisebenza kuphrojekthi yeGoogle Mapping kule mpelasonto, bengidinga ukwenza itafula ku MySQL okuhumushele izifinyezo zezwe elinezinombolo ezi-2 egameni eliphelele. Ngiyaqiniseka ukuthi le yinto edingeka kancane, ngakho-ke ngibeke ifayela le-SQL kuseva yami ukuze ilandwe.

Nasi isitatimende se-SQL seZifinyezo Zombuso Nezifundazwe ze-United States neCanada. Ngibuye ngangeza i-Index kuwo womabili ama-id nezwe ukuze ngithuthukise ukusebenza.

DALA Ithebula `ithi` (` `COUNTRYID` varchar (2) NOT NULL,` STATEID` varchar (2) NOT NULL, `FULLNAME` varchar (30) NOT NULL, KEY` country` (`COUNTRYID`), KEY` id` (`STATEID`)) INJINI = I-MyISAM DEFAULT CHARSET = utf8 COMMENT = 'Ukubheka Igama Lesifundazwe Nesifundazwe Okugcwele kwe-US neCanada';
FAKA I-```` (`COUNTRYID`,` STATEID`, `FULLNAME`) VALUES ('CA', 'AB', 'Alberta'), ('CA', 'BC', 'British Columbia'), (' I-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', 'i-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', 'Mashi yland '), (' US ',' ME ',' Maine '), (' US ',' MI ',' Michigan '), (' US ',' MN ',' Minnesota '), (' US ' , 'MO', 'Missouri'), ('US', 'MS', 'Mississippi'), ('US', 'MT', 'Montana'), ('US', 'NC', 'iNorth 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', 'iVirgin Islands'), ('US', 'VT', 'Vermont'), ('US', 'WA' , 'Washington'), ('US', 'WI', 'Wisconsin'), ('US', 'WV', 'West Virginia'), ('US', 'WY', 'Wyoming');

Isigqoko sesigqoko ku UBrian owayene-CSV enhle Ngikwazile ukusebenza kusuka.

UCABANGANI?

Le sayithi isebenzisa i-Akismet ukunciphisa ugaxekile. Funda ukuthi idatha yakho yokuphawula isetshenziswa kanjani.