I-SQL: UkuKhangela okuPheleleyo kwamaZwe kunye namaPhondo e-US naseCanada

amantla Emelika

Ngelixa ndisebenza kwiprojekthi yeMephu kaGoogle kule mpelaveki, kuye kwafuneka ndenze itafile kuyo MySQL eliguqulele ilizwe elinemivo emi-2 kunye nezifinyezo zikarhulumente kwigama elipheleleyo Ndiqinisekile ukuba le yinto efunekayo kancinci, ke ndibeke ifayile ye-SQL kwiseva yam yokukhuphela.

Nantsi ingxelo ye-SQL yeZifinyezo zikaRhulumente nePhondo zaseMelika naseKhanada. Ndongeze i-Index kuwo omabini amazwe nakwizazisi zikarhulumente ukuphucula ukusebenza.

YENZA ISICWANGCISO` 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 = 'I-State kunye nePhondo Igama elipheleleyo lokuKhangela e-US nase Canada';
FAKA IZINTO `` ithi '(`COUNTRYID`,` STATEID`,' FULLNAME`) VALUES ('CA', 'AB', 'Alberta'), ('CA', 'BC', 'British Columbia'), (' CA ',' MB ',' Manitoba '), (' CA ',' NB ',' New Brunswick '), (' CA ',' NL ',' iNewfoundland kunye neLabrador '), (' CA ',' NS ' ',' Nova Scotia '), (' CA ',' NT ',' iNtshona West Territories '), (' CA ',' NU ',' Nunavut '), (' CA ',' ON ',' Ontario ') , '' CA ',' PE ',' iPrince Edward Island '), (' CA ',' QC ',' Quebec '), (' CA ',' SK ',' Saskatachewan '), (' CA ', 'YT', 'Yukon'), ('US', 'AK', 'Alaska'), ('US', 'AL', 'Alabama'), ('US', 'AR', 'iArkansas') , ('US', 'AZ', 'Arizona'), ('US', 'CA', 'California'), ('US', 'CO', 'iColorado'), ('US', 'CT ',' Connecticut '), (' US ',' DC ',' iSithili saseColumbia '), (' 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', 'EyoKwindla ('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', 'iNew Hampshire'), ('iUS ',' NJ ',' New Jersey '), (' US ',' NM ',' iNew Mexico '), (' US ',' NV ',' Nevada '), (' US ',' NY ', '(New York'), ('US', 'OH', 'Ohio'), ('US', 'Kulungile', 'Oklahoma'), ('US', 'OKANYE', 'Oregon'), (' US ',' PA ',' Pennsylvania '), (' US ',' RI ',' Rhode Island '), (' US ',' SC ',' South Carolina '), (' US ',' SD ' , 'Mzantsi Dakota'), ('US', 'TN', 'Tennessee'), ('US', 'TX', 'Texas'), ('US', 'UT', 'Utah'), ( 'US', 'VA', 'Virginia'), ('US', 'VI', 'iVirgin Islands'), ('US', 'VT', 'iVermont'), ('US', 'WA') , 'Washington'), ('US', 'WI', 'Wisconsin'), ('US', 'WV', 'West Virginia'), ('US', 'WY', 'Ukuza');

Ingcebiso yomnqwazi ku UBrian owayene-CSV entle Ndikwazile ukusebenza ukusuka.

Ingaba ucinga ntoni?

Le sayithi isebenzisa i-Akismet ukunciphisa ugaxekile. Funda indlela idatha yakho yokubhaliweyo isetyenziswe ngayo.