SQL: Aha nyocha zuru oke maka States na Provinces maka US na Canada

North America

Mgbe m na-arụ ọrụ na Google Mapping project na ngwụcha izu a, ọ dị m mkpa ịme tebụl na MySQL nke ahụ sụgharịrị mba 2-ọnụọgụ na ndebiri ndebiri gaa aha zuru ezu. Ekwenyesiri m ike na nke a bụ ihe achọrọ ntakịrị, yabụ etinyela m faịlụ SQL na sava m maka nbudata.

Nke a bụ nkwupụta SQL maka State na Abbreviations nke United States na Canada. Etinyekwala m Index na mba ma ọ bụ steeti steeti iji melite arụmọrụ.

CREATE Isiokwu```` '' COUNTRYID` varchar (2) B NGHULL NULL, `` STATEID` varchar (2) B NGHULL, (`` STATEID`)) ENGINE = MyISAM DEFAULT CHARSET = utf30 COMMENT = 'Ọchịchị na Mpaghara Aha Aha Aha US na Canada';
Tinye n'ime `` kwuru`` ('' COUNTRYID`, `` CA ',' MB ',' Manitoba '), (' CA ',' NB ',' New Brunswick '), (' CA ',' NL ',' Newfoundland and 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 nke 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 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', 'Virgin Islands'), ('US', 'VT', 'Vermont'), ('US', 'WA' , 'Washington'), ('US', 'WI', 'Wisconsin'), ('US', 'WV', 'West Virginia'), ('US', 'WY', 'Wyoming');

Okpu okpu na- Brian onye nwere ezigbo CSV Enwere m ike ịrụ ọrụ site na.

Kedu ihe ị chere?

Ebe a na-eji Akismet iji belata spam. Mụta otu esi etinye usoro data gị.