Marketing okhutira

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

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.

Douglas Karr

Douglas Karr ndi CMO OpenINSIGHTS ndi woyambitsa wa Martech Zone. Douglas wathandizira oyambitsa ambiri opambana a MarTech, wathandizira kulimbikira kopitilira $ 5 bil pakugula ndi kuyika kwa Martech, ndipo akupitiliza kuthandiza makampani kukhazikitsa ndikusintha njira zawo zogulitsa ndi zotsatsa. Douglas ndi katswiri wodziwika padziko lonse lapansi wosinthira digito komanso katswiri komanso wokamba nkhani wa MarTech. Douglas ndi mlembi wofalitsidwa wa kalozera wa Dummie komanso buku la utsogoleri wabizinesi.

Nkhani

Bwererani pamwamba
Close

Adblock yapezeka

Martech Zone imatha kukupatsirani izi popanda mtengo chifukwa timapanga ndalama patsamba lathu kudzera muzotsatsa, maulalo ogwirizana, komanso kuthandizira. Tingayamikire ngati mungachotse choletsa ad mukamawona tsamba lathu.