SQL: Lub Npe Tag Nrho Saib rau Cov Xeev thiab Cov Xeev rau Asmeskas thiab Canada
Thaum ua haujlwm rau Google Qhov Phiaj xwm Daim phiaj xwm hnub so no, Kuv xav tau los ua ib lub rooj hauv MySQL uas txhais 2-lej lej hauv lub tebchaws thiab lub xeev cov ntawv luv rau tag nrho lub npe. Kuv paub tseeb tias qhov no yog qee yam uas xav tau me ntsis, yog li kuv tau muab SQL cov ntawv cia ntawm kuv lub server rau download.
Ntawm no yog tsab ntawv SQL rau Lub Xeev thiab Xeev Cov Ntawv luv luv rau Tebchaws Asmeskas thiab Canada. Kuv tseem tau ntxiv qhov Index rau ntawm ob lub tebchaws thiab xeev tus cim rau txhim kho kev ua haujlwm.
COJ LUB ROOJ `xeev` (` COUNTRYID `varchar (2) TSIS PUB,` STATEID `varchar (2) TSIS PUB,` FULLNAME `varchar (30) TSIS PUB, TSEEM CEEB` lub teb chaws (`COUNTRYID`), TSEEM CEEB ʻid` (`STATEID`)) CAV = MyISAM DEFAULT CHARSET = utf8 COMMENT = 'Xeev thiab Xeev Tag Nrho Cov Npe Saib rau Asmeskas thiab Canada';
INSERT INTO `states` (` COUNTRYID`, `STATEID`,` FULLNAME`) VALUES ('CA', 'AB', 'Alberta'), ('CA', 'BC', 'British Columbia'), (' CA ',' MB ',' Manitoba '), (' CA ',' NB ',' New Brunswick '), (' CA ',' NL ',' Newfoundland thiab 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'), ('Asmeskas', 'AL', 'Alabama'), ('Asmeskas', 'AR', 'Arkansas') , ('Asmeskas', 'AZ', 'Arizona'), ('Asmeskas', 'CA', 'California'), ('Asmeskas', 'CO', 'Colorado'), ('US', 'CT ',' Connecticut '), (' US ',' DC ',' District of Columbia '), (' Asmeskas ',' DE ',' Delaware '), (' Asmeskas ',' FL ',' Florida ') , ('Asmeskas', 'GA', 'Georgia'), ('Asmeskas', 'HI', 'Hawaii'), ('Asmeskas', 'IA', 'Iowa'), ('US', 'ID ',' Idaho '), (' US ',' IL ',' Illinois '), (' Asmeskas ',' IN ',' Indiana '), (' Asmeskas ',' KS ',' Kansas '), ( 'Asmeskas', 'KY', 'Kentucky'), ('Asmeskas', 'LA', 'Louisiana'), ('Asmeskas', 'MA', 'Massachusetts'), ('US', 'MD', 'Mar yland '), (' Asmeskas ',' ME ',' Maine '), (' Asmeskas ',' MI ',' Michigan '), (' Asmeskas ',' MN ',' Minnesota '), (' US ' , 'MO', 'Missouri'), ('Asmeskas', 'MS', 'Mississippi'), ('Asmeskas', 'MT', 'Montana'), ('Asmeskas', 'NC', 'North Carolina '), (' Asmeskas ',' ND ',' North Dakota '), (' Asmeskas ',' NE ',' Nebraska '), (' Asmeskas ',' NH ',' New Hampshire '), (' Asmeskas ',' NJ ',' New Jersey '), (' US ',' NM ',' New Mexico '), (' US ',' NV ',' Nevada '), (' US ',' NY ', 'New York'), ('US', 'OH', 'Ohio'), ('US', 'OK', 'Oklahoma'), ('US', 'OR', 'Oregon'), (' Asmeskas ',' PA ',' Pennsylvania '), (' Asmeskas ',' RI ',' Rhode Island '), (' Asmeskas ',' SC ',' South Carolina '), (' US ',' SD ' , 'South Dakota'), ('US', 'TN', 'Tennessee'), ('Asmeskas', 'TX', 'Texas'), ('Asmeskas', 'UT', 'Utah'), ( 'US', 'VA', 'Virginia'), ('US', 'VI', 'Virgin Islands'), ('US', 'VT', 'Vermont'), ('US', 'WA' , 'Washington'), ('Asmeskas', 'WI', 'Wisconsin'), ('Asmeskas', 'WV', 'West Virginia'), ('Asmeskas', 'WY', 'Wyoming');
Kaus lub taub rau Brian uas muaj CSV zoo Kuv tau ua haujlwm los ntawm.