📄 compress.result
字号:
fld5neatSteinbergjarringtinilyballedpersistattainmentsfanaticmeasuresrightfulnessselect distinct fld3,count(*) from t2 group by companynr,fld3 limit 10;fld3 count(*)affixed 1and 1annoyers 1Anthony 1assayed 1assurers 1attendants 1bedlam 1bedpost 1boasted 1SET SQL_BIG_TABLES=1;select distinct fld3,count(*) from t2 group by companynr,fld3 limit 10;fld3 count(*)affixed 1and 1annoyers 1Anthony 1assayed 1assurers 1attendants 1bedlam 1bedpost 1boasted 1SET SQL_BIG_TABLES=0;select distinct fld3,repeat("a",length(fld3)),count(*) from t2 group by companynr,fld3 limit 100,10;fld3 repeat("a",length(fld3)) count(*)circus aaaaaa 1cited aaaaa 1Colombo aaaaaaa 1congresswoman aaaaaaaaaaaaa 1contrition aaaaaaaaaa 1corny aaaaa 1cultivation aaaaaaaaaaa 1definiteness aaaaaaaaaaaa 1demultiplex aaaaaaaaaaa 1disappointing aaaaaaaaaaaaa 1select distinct companynr,rtrim(space(512+companynr)) from t3 order by 1,2;companynr rtrim(space(512+companynr))37 78 101 154 311 447 512 select distinct fld3 from t2,t3 where t2.companynr = 34 and t2.fld1=t3.t2nr order by fld3;fld3explain select t3.t2nr,fld3 from t2,t3 where t2.companynr = 34 and t2.fld1=t3.t2nr order by t3.t2nr,fld3;id select_type table type possible_keys key key_len ref rows Extra1 SIMPLE t2 ALL fld1 NULL NULL NULL 1199 Using where; Using temporary; Using filesort1 SIMPLE t3 eq_ref PRIMARY PRIMARY 4 test.t2.fld1 1 Using where; Using indexexplain select * from t3 as t1,t3 where t1.period=t3.period order by t3.period;id select_type table type possible_keys key key_len ref rows Extra1 SIMPLE t1 ALL period NULL NULL NULL 41810 Using temporary; Using filesort1 SIMPLE t3 ref period period 4 test.t1.period 4181 explain select * from t3 as t1,t3 where t1.period=t3.period order by t3.period limit 10;id select_type table type possible_keys key key_len ref rows Extra1 SIMPLE t3 index period period 4 NULL 41810 1 SIMPLE t1 ref period period 4 test.t3.period 4181 explain select * from t3 as t1,t3 where t1.period=t3.period order by t1.period limit 10;id select_type table type possible_keys key key_len ref rows Extra1 SIMPLE t1 index period period 4 NULL 41810 1 SIMPLE t3 ref period period 4 test.t1.period 4181 select period from t1;period9410select period from t1 where period=1900;periodselect fld3,period from t1,t2 where fld1 = 011401 order by period;fld3 periodbreaking 9410select fld3,period from t2,t3 where t2.fld1 = 011401 and t2.fld1=t3.t2nr and t3.period=1001;fld3 periodbreaking 1001explain select fld3,period from t2,t3 where t2.fld1 = 011401 and t3.t2nr=t2.fld1 and 1001 = t3.period;id select_type table type possible_keys key key_len ref rows Extra1 SIMPLE t2 const fld1 fld1 4 const 1 1 SIMPLE t3 const PRIMARY,period PRIMARY 4 const 1 select fld3,period from t2,t1 where companynr*10 = 37*10;fld3 periodbreaking 9410Romans 9410intercepted 9410bewilderingly 9410astound 9410admonishing 9410sumac 9410flanking 9410combed 9410subjective 9410scatterbrain 9410Eulerian 9410Kane 9410overlay 9410perturb 9410goblins 9410annihilates 9410Wotan 9410snatching 9410concludes 9410laterally 9410yelped 9410grazing 9410Baird 9410celery 9410misunderstander 9410handgun 9410foldout 9410mystic 9410succumbed 9410Nabisco 9410fingerings 9410aging 9410afield 9410ammonium 9410boat 9410intelligibility 9410Augustine 9410teethe 9410dreaded 9410scholastics 9410audiology 9410wallet 9410parters 9410eschew 9410quitter 9410neat 9410Steinberg 9410jarring 9410tinily 9410balled 9410persist 9410attainments 9410fanatic 9410measures 9410rightfulness 9410capably 9410impulsive 9410starlet 9410terminators 9410untying 9410announces 9410featherweight 9410pessimist 9410daughter 9410decliner 9410lawgiver 9410stated 9410readable 9410attrition 9410cascade 9410motors 9410interrogate 9410pests 9410stairway 9410dopers 9410testicle 9410Parsifal 9410leavings 9410postulation 9410squeaking 9410contrasted 9410leftover 9410whiteners 9410erases 9410Punjab 9410Merritt 9410Quixotism 9410sweetish 9410dogging 9410scornfully 9410bellow 9410bills 9410cupboard 9410sureties 9410puddings 9410fetters 9410bivalves 9410incurring 9410Adolph 9410pithed 9410Miles 9410trimmings 9410tragedies 9410skulking 9410flint 9410flopping 9410relaxing 9410offload 9410suites 9410lists 9410animized 9410multilayer 9410standardizes 9410Judas 9410vacuuming 9410dentally 9410humanness 9410inch 9410Weissmuller 9410irresponsibly 9410luckily 9410culled 9410medical 9410bloodbath 9410subschema 9410animals 9410Micronesia 9410repetitions 9410Antares 9410ventilate 9410pityingly 9410interdependent 9410Graves 9410neonatal 9410chafe 9410honoring 9410realtor 9410elite 9410funereal 9410abrogating 9410sorters 9410Conley 9410lectured 9410Abraham 9410Hawaii 9410cage 9410hushes 9410Simla 9410reporters 9410Dutchman 9410descendants 9410groupings 9410dissociate 9410coexist 9410Beebe 9410Taoism 9410Connally 9410fetched 9410checkpoints 9410rusting 9410galling 9410obliterates 9410traitor 9410resumes 9410analyzable 9410terminator 9410gritty 9410firearm 9410minima 9410Selfridge 9410disable 9410witchcraft 9410betroth 9410Manhattanize 9410imprint 9410peeked 9410swelling 9410interrelationships 9410riser 9410Gandhian 9410peacock 9410bee 9410kanji 9410dental 9410scarf 9410chasm 9410insolence 9410syndicate 9410alike 9410imperial 9410convulsion 9410railway 9410validate 9410normalizes 9410comprehensive 9410chewing 9410denizen 9410schemer 9410chronicle 9410Kline 9410Anatole 9410partridges 9410brunch 9410recruited 9410dimensions 9410Chicana 9410announced 9410praised 9410employing 9410linear 9410quagmire 9410western 9410relishing 9410serving 9410scheduling 9410lore 9410eventful 9410arteriole 9410disentangle 9410cured 9410Fenton 9410avoidable 9410drains 9410detectably 9410husky 9410impelling 9410undoes 9410evened 9410squeezes 9410destroyer 9410rudeness 9410beaner 9410boorish 9410Everhart 9410encompass 9410mushrooms 9410Alison 9410externally 9410pellagra 9410cult 9410creek 9410Huffman 9410Majorca 9410governing 9410gadfly 9410reassigned 9410intentness 9410craziness 9410psychic 9410squabbled 9410burlesque 9410capped 9410extracted 9410DiMaggio 9410exclamation 9410subdirectory 9410Gothicism 9410feminine 9410metaphysically 9410sanding 9410Miltonism 9410freakish 9410index 9410straight 9410flurried 9410denotative 9410coming 9410commencements 9410gentleman 9410gifted 9410Shanghais 9410sportswriting 9410sloping 9410navies 9410leaflet 9410shooter 9410Joplin 9410babies 9410assails 9410admiring 9410swaying 9410Goldstine 9410fitting 9410Norwalk 9410analogy 9410deludes 9410cokes 9410Clayton 9410exhausts 9410causality 9410sating 9410icon 9410throttles 9410communicants 9410dehydrate 9410priceless 9410publicly 9410incidentals 9410commonplace 9410mumbles 9410furthermore 9410cautioned 9410parametrized 9410registration 9410sadly 9410positioning 9410babysitting 9410eternal 9410hoarder 9410congregates 9410rains 9410workers 9410sags 9410unplug 9410garage 9410boulder 9410specifics 9410Teresa 9410Winsett 9410convenient 9410buckboards 9410amenities 9410resplendent 9410sews 9410participated 9410Simon 9410certificates 9410Fitzpatrick 9410Evanston 9410misted 9410textures 9410save 9410count 9410rightful 9410chaperone 9410Lizzy 9410clenched 9410effortlessly 9410accessed 9410beaters 9410Hornblower 9410vests 9410indulgences 9410infallibly 9410unwilling 9410excrete 9410spools 9410crunches 9410overestimating 9410ineffective 9410humiliation 9410sophomore 9410star 9410rifles 9410dialysis 9410arriving 9410indulge 9410clockers 9410languages 9410Antarctica 9410percentage 9410ceiling 9410specification 9410regimented 9410ciphers 9410pictures 9410serpents 9410allot 9410realized 9410mayoral 9410opaquely 9410hostess 9410fiftieth 9410incorrectly 9410decomposition 9410stranglings 9410mixture 9410electroencephalography 9410similarities 9410charges 9410freest 9410Greenberg 9410tinting 9410expelled 9410warm 9410smoothed 9410deductions 9410Romano 9410bitterroot 9410corset 9410securing 9410environing 9410cute 9410Crays 9410heiress 9410inform 9410avenge 9410universals 9410Kinsey 9410ravines 9410bestseller 9410equilibrium 9410extents 9410relatively 9410pressure 9410critiques 9410befouled 9410rightfully 9410mechanizing 9410Latinizes 9410timesharing 9410Aden 9410embassies 9410males 9410shapelessly 9410mastering 9410Newtonian 9410finishers 9410abates 9410teem 9410kiting 9410stodgy 9410feed 9410guitars 9410airships 9410store 9410denounces 9410Pyle 9410Saxony 9410serializations 9410Peruvian 9410taxonomically 9410kingdom 9410stint 9410Sault 9410faithful 9410Ganymede 9410tidiness 9410gainful 9410contrary 9410Tipperary 9410tropics 9410theorizers 9410renew 9410already 9410terminal 9410⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -