📄 csv.result
字号:
drop table if exists t1,t2,t3,t4;CREATE TABLE t1 (Period smallint(4) unsigned zerofill DEFAULT '0000' NOT NULL,Varor_period smallint(4) unsigned DEFAULT '0' NOT NULL) ENGINE = CSV;INSERT INTO t1 VALUES (9410,9412);select period from t1;period9410select * from t1;Period Varor_period9410 9412select t1.* from t1;Period Varor_period9410 9412CREATE TABLE t2 (auto int not null,fld1 int(6) unsigned zerofill DEFAULT '000000' NOT NULL,companynr tinyint(2) unsigned zerofill DEFAULT '00' NOT NULL,fld3 char(30) DEFAULT '' NOT NULL,fld4 char(35) DEFAULT '' NOT NULL,fld5 char(35) DEFAULT '' NOT NULL,fld6 char(4) DEFAULT '' NOT NULL) ENGINE = CSV;select t2.fld3 from t2 where companynr = 58 and fld3 like "%imaginable%";fld3imaginableselect fld3 from t2 where fld3 like "%cultivation" ;fld3cultivationselect t2.fld3,companynr from t2 where companynr = 57+1 order by fld3;fld3 companynrconcoct 58druggists 58engrossing 58Eurydice 58exclaimers 58ferociousness 58hopelessness 58Huey 58imaginable 58judges 58merging 58ostrich 58peering 58Phelps 58presumes 58Ruth 58sentences 58Shylock 58straggled 58synergy 58thanking 58tying 58unlocks 58select fld3,companynr from t2 where companynr = 58 order by fld3;fld3 companynrconcoct 58druggists 58engrossing 58Eurydice 58exclaimers 58ferociousness 58hopelessness 58Huey 58imaginable 58judges 58merging 58ostrich 58peering 58Phelps 58presumes 58Ruth 58sentences 58Shylock 58straggled 58synergy 58thanking 58tying 58unlocks 58select fld3 from t2 order by fld3 desc limit 10;fld3youthfulnessyelpedWotanworkersWittwitchcraftWinsettWillywilledwildcatsselect fld3 from t2 order by fld3 desc limit 5;fld3youthfulnessyelpedWotanworkersWittselect fld3 from t2 order by fld3 desc limit 5,5;fld3witchcraftWinsettWillywilledwildcatsUPDATE t2 SET fld3="foo" WHERE fld3="b%";select fld3 from t2;fld3OmahabreakingRomansinterceptedbewilderinglyastoundadmonishingsumacflankingcombedsubjectivescatterbrainEuleriandubbedKaneoverlayperturbgoblinsannihilatesWotansnatchingconcludeslaterallyyelpedgrazingBairdcelerymisunderstanderhandgunfoldoutmysticsuccumbedNabiscofingeringsagingafieldammoniumboatintelligibilityAugustineteethedreadedscholasticsaudiologywalletparterseschewquitterneatSteinbergjarringtinilyballedpersistattainmentsfanaticmeasuresrightfulnesscapablyimpulsivestarletterminatorsuntyingannouncesfeatherweightpessimistdaughterdeclinerlawgiverstatedreadableattritioncascademotorsinterrogatepestsstairwaydoperstesticleParsifalleavingspostulationsqueakingcontrastedleftoverwhitenerserasesPunjabMerrittQuixotismsweetishdoggingscornfullybellowbillscupboardsuretiespuddingstapestryfettersbivalvesincurringAdolphpithedemergencyMilestrimmingstragediesskulkingflintfloppingrelaxingoffloadsuiteslistsanimizedmultilayerstandardizesJudasvacuumingdentallyhumannessinchWeissmullerirresponsiblyluckilyculledmedicalbloodbathsubschemaanimalsMicronesiarepetitionsAntaresventilatepityinglyinterdependentGravesneonatalscribbledchafehonoringrealtorelitefunerealabrogatingsortersConleylecturedAbrahamHawaiicagehushesSimlareportersDutchmandescendantsgroupingsdissociatecoexistBeebeTaoismConnallyfetchedcheckpointsrustinggallingobliteratestraitorresumesanalyzableterminatorgrittyfirearmminimaSelfridgedisablewitchcraftbetrothManhattanizeimprintpeekedswellinginterrelationshipsriserGandhianpeacockbeekanjidentalscarfchasminsolencesyndicatealikeimperialconvulsionrailwayvalidatenormalizescomprehensivechewingdenizenschemerchronicleKlineAnatolepartridgesbrunchrecruiteddimensionsChicanaannouncedpraisedemployinglinearquagmirewesternrelishingservingschedulingloreeventfularterioledisentanglecuredFentonavoidabledrainsdetectablyhuskyimpellingundoesevenedsqueezesdestroyerrudenessbeanerboorishEverhartencompassmushroomsAlisonexternallypellagracultcreekHuffmanMajorcagoverninggadflyreassignedintentnesscrazinesspsychicsquabbledburlesquecappedextractedDiMaggioexclamationsubdirectoryfangsbuyerpithingtransistorizingnonbiodegradabledislocatemonochromaticbattingpostconditioncatalogRemusdevicesbikequalifydetainedcommendedcivilizeElmhurstanesthetizingdeafBrighamtitlecoarsecombinationsgraynessinnumerableCarolinefattyeastboundinexperiencedhoarderscotchpassportstrategicgatedflogPipestoneDarCorcoranflyerscompetitionssuppliersskipsinstitutestroopconnectivedeniespolkaobservationsaskershomelessAnnasubdirectoriesdecayingoutwittingHarpycrazedsuffocateproverstechnicallyFranklinizationsconsideredtinnilyuninterruptedlywhistledautomateguttingsurreptitiousChoctawcooksmillivoltcounterpoiseGothicismfemininemetaphysicallysandingcontributorilyreceiversadjournstraggleddruggiststhankingostrichhopelessnessEurydiceexcitationpresumesimaginableconcoctpeeringPhelpsferociousnesssentencesunlocksengrossingRuthtyingexclaimerssynergyHueymergingjudgesShylockMiltonismhenhoneybeetowersdilutesnumeralsdemocracyIbero-invalidsbehavioraccruingrelicsracketsFischbeinphonycrosscleanupconspiratorlabeluniversitycleansedballgownstarletaqueousportrayaldespisingdistortpalmedfacedsilverwareassessorspidersartificiallyreminiscenceMexicanobnoxiousfragileapprehensiblebirthsgaragespantyanteaterdisplacementdroverspatentingfarshrieksaligningpragmatismfeversreexaminesoccupanciessweatsmodulatorsdemandMadeiraViennesechillierwildcatsgentleAnglesaccuraciestoggleMendelssohnbehaviorallyRochfordmirrorModulaclobberingchronographyEskimoizedsBritishpitfallsverifyscatterAztecanacuitysinkingbeastsWittphysicistsfolksongstrokescrowdermerrycadencedalimonyprincipledgolfingundiscoveredirritatespatriotsroomstoweringdispleasephotosensitiveinkinggainersleaninghydrantpreserveblindedinteractionsBarrywhitenesspastimesEdenizationMuscatassassinatedlabeledglacialimpliedbibliographiesBuchananforgivablyinnuendodensubmarinesmouthfulexpiringunfulfilledprecessionnullifiedaffectsCynthiaChablisbettermentsadvertisingrubiessouthwestsuperstitioustabernaclesilkhandsomestPersiananalogcomplexTaoistsuspendrelegatedawesomeBruxellesimpreciselytelevisebrakingtruedisappointingnavallycircusbeetlestrumpsfourscoreBlackfootsGradyquietsflounderedprofundityGarrisonianStrausscementedcontritionmutationsexhibitstitsmatearchesMollropersbombastdifficultlyadsorptiondefinitenesscultivationhealsHeusentargetcitedcongresswomanKatherinetitteraspireMardisNadiaestimatingstuckfifteenthColombosurveystaffingobtainloadedslaughteredlightscircumferencedullweeklywetnessvisualizedTannenbaummoribunddemultiplexlockingsthugsunnervesabutChippewastratificationssignaledItalianizesalgorithmicparanoidcampingsignifyingPatricesearchAngelessemblancetaxedBeatriceretracelockoutgrammatichelmsmanuniformhammingdisobediencecaptivatedtransferalscartographeraimsPakistaniburglarizedsaucepanslaceratingcornymegabyteschancellorbulkcommitsmesondeputiesnortheasterdipolemachiningthereforeTelefunkensalvagingCorinthianizesrestlesslybromidesgeneralizedmishapsquellingspiritualbeguilesTrobriandfleeingArmourchinproversaeronauticvoltagesashanaerobicsimultaneousaccumulatingMedusanshoutedfreakishindexcommerciallymistinessendpointstraightflurrieddenotativecomingcommencementsgentlemangiftedShanghaissportswritingslopingnaviesleafletshooterJoplinbabiessubdivisionburstinessbeltedassailsadmiringswayingGoldstinefittingNorwalkweakeninganalogydeludescokesClaytonexhaustscausalitysatingiconthrottlescommunicantsdehydratepricelesspubliclyincidentalscommonplacemumblesfurthermorecautionedparametrizedregistrationsadlypositioningbabysittingeternalhoardercongregatesrainsworkerssagsunpluggarageboulderhollowlyspecificsTeresaWinsettconvenientbuckboardsamenitiesresplendentpridingconfigurationsuntidinessBricesewsparticipatedSimoncertificatesFitzpatrickEvanstonmistedtexturessavecountrightfulchaperoneLizzyclenchedeffortlesslyaccessedbeatersHornblowervestsindulgencesinfalliblyunwillingexcretespoolscrunchesoverestimatingineffectivehumiliationsophomorestarriflesdialysisarrivingindulgeclockerslanguagesAntarcticapercentageceilingspecificationregimentedcipherspicturesserpentsallotrealizedmayoralopaquelyhostessfiftiethincorrectlydecompositionstranglingsmixtureelectroencephalographysimilaritieschargesfreestGreenbergtintingexpelledwarmsmootheddeductionsRomanobitterrootcorsetsecuringenvironingcuteCraysheiressinformavengeuniversalsKinseyravinesbestsellerequilibriumextentsrelativelypressurecritiquesbefouledrightfullymechanizingLatinizestimesharingAdenembassiesmalesshapelesslygenresmasteringNewtonianfinishersabatesteemkitingstodgyscalpsfeedguitarsairshipsstoredenouncesPyleSaxonyserializationsPeruviantaxonomicallykingdomstintSaultfaithfulGanymedetidinessgainfulcontraryTipperarytropicstheorizersrenewalreadyterminalHegelianhypothesizerwarninglyjournalizingnestedLarssaplingsfoothilllabeledimperiouslyreportersfurnishingsprecipitablediscountsexcisesStalindespotripenessArabiaunrulymournfulnessboomslaughterSabinehandyruralorganizershipyardcivicsinaccuracyrulesjuvenilescomprisedinvestigationsstabilizesseminariesHuntersportytestweaselsCERNtemperingaforeGalateantechniqueserrorverandaseverelyCassitesforthcomingguidesvanishliedsawtoothfatedgraduallywidensprecludeJobrelhookerrainstormdisconnectscrueltyexponentialsaffectivearteriesCrosbyacquaintevenhandedlypercentagedisobediencehumilitygleaningpettedbloaterminionmarginalapiarymeasuresprecautionrepelledprimarycoveringsArtemianavigatespatialGurkhameanwhileMelindaButterfieldAldrichpreviewingglutunaffectedinmatemineralimpendingmeditationideasminiaturizeslewdlytitleyouthfulnesscreakChippewaclamoredfreezesforgivablyreduceMcGovernNazisepistlesocializesconceptionsKevinuncoveringchewsappendixesappendixesappendixesappendixesappendixesappendixesraininginfestcompartmentmintingducksropedwaltzLillianrepressionschillinglynoncriticallithographspongersparenthoodposedinstrumentsfilialfixedlyrelivesPandorawateringungratefulsecureschastisersiconreunitingimaginingabidingomniscientlyBritannicscholasticsmechanicshumidlymasterpiecehoweverMendelianjarredscoldsinfatuatewilledjoyfullyMicrosoftfibrositiesBaltimoreanequestrianGoodrichapishAdlerianTropeznounsdistractingmuttonbridgeablestickerstranscontinentalamateurishGandhianstratifiedchamberlainscreditablyphilosophicoresCarletontapeafloatgoodnesswelcomingPinskyhaltingbibliographydecodingvariancealloweddiredubpoisoningIraqisheavingpopulationbombMajorcaGershwinsexplorerslibrettooccurredLagosratsbankruptciescryingunexpectedaccessedcolorfulversatilitycosyDariusmasteringAsiaticizationsofferersunclessleepwalkErnestinechecksummingstoppedsickerItalianizationalphabeticpharmaceuticcreatorchesscharcoalEpiphanybulldozesPygmalioncaressingPalestineregimentedscarsrealestdiffusingclubroomBlytheaheadreviverretransmittinglandslideEiffelabsenteeayeforkedPeruvianizesclerkedtutorboulevardshutteredquotesCaltechMossbergkeptroundlyfeaturesimaginablecontrollerracialuprisingsnarrowedcannotvestfaminesugarsexterminatedbelaysHodgestranslatabledualityrecordingrousespoisonattitudedustedencompassespresentationKantianimprecisionsavingmaternalhewedkeroseneCubansphotographersnymphbedlamnorthSchoenbergbotanycurssolidificationinheritressesstillert1suiteransomerWillyRenaSeattlerelaxesexclaimexclaimimplicateddistinguishassayedhomeownerandstealth⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -