Content Marketing

SQL: Cikakken Suna na Neman Jihohi da Larduna na Amurka da Kanada

Yayin aiki a kan Taswirar Taswirar Google a ƙarshen wannan satin, ina buƙatar yin tebur a ciki MySQL wannan ya fassara ƙasar lambobi 2 da kuma taƙaitawar jihohi zuwa cikakken suna. Na tabbata wannan wani abu ne da ake buƙata kaɗan, don haka na sanya fayil ɗin SQL a kan sabina don saukarwa.

Ga bayanin SQL na gajerun Jihohi da Larduna ga Amurka da Kanada. Na kuma kara Fihirisa kan kasar da rashin idda na jihar don inganta ayyuka.

CREATE TABLE `` (`` COUNTRYID` varchar (2) BA NULL bane, '' STATEID` varchar (2) BA NULL, `` FULLNAME` varchar (30) BA NULL, KEY 'country` (' COUNTRYID`), KEY ʻid` (`` STATEID`)) ENGINE = MyISAM DEFAULT CHARSET = utf8 COMMENT = 'Jiha da Lardin Cikakken Suna na Neman Amurka da Kanada';
Saka cikin `` ('' COUNTRYID`, `` STATEID`, '' FULLNAME`) VALUES ('CA', 'AB', 'Alberta'), ('CA', 'BC', 'British Columbia'), (' CA ',' MB ',' Manitoba '), (' CA ',' NB ',' New Brunswick '), (' CA ',' NL ',' Newfoundland and Labrador '), (' CA ',' NS ',' Nova Scotia '), (' CA ',' NT ',' Yankin Arewa Maso Yamma '), (' 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 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');

Hat hat zuwa Brian wanda yake da CSV mai kyau Na sami damar yin aiki daga.

Douglas Karr

Douglas Karr shine CMO Bude INSIGHTS kuma wanda ya kafa Martech Zone. Douglas ya taimaka da yawa na nasara MarTech farawa, ya taimaka a cikin ƙwazo na sama da $5 biliyan a Martech saye da zuba jari, kuma ya ci gaba da taimaka wa kamfanoni wajen aiwatar da sarrafa sarrafa tallace-tallace da dabarun talla. Douglas ƙwararren ƙwararren dijital ne na duniya kuma ƙwararren MarTech kuma mai magana. Douglas kuma marubuci ne da aka buga na jagorar Dummie da kuma littafin jagoranci na kasuwanci.

shafi Articles

Komawa zuwa maɓallin kewayawa
Close

An Gano Adblock

Martech Zone zai iya ba ku wannan abun cikin ba tare da farashi ba saboda muna yin monetize da rukunin yanar gizon mu ta hanyar kudaden talla, hanyoyin haɗin gwiwa, da tallafi. Za mu yi godiya idan za ku cire mai hana tallan ku yayin da kuke duba rukunin yanar gizon mu.