📄 compress.result
字号:
Hegelian 9410hypothesizer 9410warningly 9410journalizing 9410nested 9410Lars 9410saplings 9410foothill 9410labeled 9410imperiously 9410reporters 9410furnishings 9410precipitable 9410discounts 9410excises 9410Stalin 9410despot 9410ripeness 9410Arabia 9410unruly 9410mournfulness 9410boom 9410slaughter 9410Sabine 9410handy 9410rural 9410organizer 9410shipyard 9410civics 9410inaccuracy 9410rules 9410juveniles 9410comprised 9410investigations 9410stabilizes 9410seminaries 9410Hunter 9410sporty 9410test 9410weasels 9410CERN 9410tempering 9410afore 9410Galatean 9410techniques 9410error 9410veranda 9410severely 9410Cassites 9410forthcoming 9410guides 9410vanish 9410lied 9410sawtooth 9410fated 9410gradually 9410widens 9410preclude 9410evenhandedly 9410percentage 9410disobedience 9410humility 9410gleaning 9410petted 9410bloater 9410minion 9410marginal 9410apiary 9410measures 9410precaution 9410repelled 9410primary 9410coverings 9410Artemia 9410navigate 9410spatial 9410Gurkha 9410meanwhile 9410Melinda 9410Butterfield 9410Aldrich 9410previewing 9410glut 9410unaffected 9410inmate 9410mineral 9410impending 9410meditation 9410ideas 9410miniaturizes 9410lewdly 9410title 9410youthfulness 9410creak 9410Chippewa 9410clamored 9410freezes 9410forgivably 9410reduce 9410McGovern 9410Nazis 9410epistle 9410socializes 9410conceptions 9410Kevin 9410uncovering 9410chews 9410appendixes 9410appendixes 9410appendixes 9410appendixes 9410appendixes 9410appendixes 9410raining 9410infest 9410compartment 9410minting 9410ducks 9410roped 9410waltz 9410Lillian 9410repressions 9410chillingly 9410noncritical 9410lithograph 9410spongers 9410parenthood 9410posed 9410instruments 9410filial 9410fixedly 9410relives 9410Pandora 9410watering 9410ungrateful 9410secures 9410poison 9410dusted 9410encompasses 9410presentation 9410Kantian 9410select fld3,period,price,price2 from t2,t3 where t2.fld1=t3.t2nr and period >= 1001 and period <= 1002 and t2.companynr = 37 order by fld3,period, price;fld3 period price price2admonishing 1002 28357832 8723648analyzable 1002 28357832 8723648annihilates 1001 5987435 234724Antares 1002 28357832 8723648astound 1001 5987435 234724audiology 1001 5987435 234724Augustine 1002 28357832 8723648Baird 1002 28357832 8723648bewilderingly 1001 5987435 234724breaking 1001 5987435 234724Conley 1001 5987435 234724dentally 1002 28357832 8723648dissociate 1002 28357832 8723648elite 1001 5987435 234724eschew 1001 5987435 234724Eulerian 1001 5987435 234724flanking 1001 5987435 234724foldout 1002 28357832 8723648funereal 1002 28357832 8723648galling 1002 28357832 8723648Graves 1001 5987435 234724grazing 1001 5987435 234724groupings 1001 5987435 234724handgun 1001 5987435 234724humility 1002 28357832 8723648impulsive 1002 28357832 8723648inch 1001 5987435 234724intelligibility 1001 5987435 234724jarring 1001 5987435 234724lawgiver 1001 5987435 234724lectured 1002 28357832 8723648Merritt 1002 28357832 8723648neonatal 1001 5987435 234724offload 1002 28357832 8723648parters 1002 28357832 8723648pityingly 1002 28357832 8723648puddings 1002 28357832 8723648Punjab 1001 5987435 234724quitter 1002 28357832 8723648realtor 1001 5987435 234724relaxing 1001 5987435 234724repetitions 1001 5987435 234724resumes 1001 5987435 234724Romans 1002 28357832 8723648rusting 1001 5987435 234724scholastics 1001 5987435 234724skulking 1002 28357832 8723648stated 1002 28357832 8723648suites 1002 28357832 8723648sureties 1001 5987435 234724testicle 1002 28357832 8723648tinily 1002 28357832 8723648tragedies 1001 5987435 234724trimmings 1001 5987435 234724vacuuming 1001 5987435 234724ventilate 1001 5987435 234724wallet 1001 5987435 234724Weissmuller 1002 28357832 8723648Wotan 1002 28357832 8723648select t2.fld1,fld3,period,price,price2 from t2,t3 where t2.fld1>= 18201 and t2.fld1 <= 18811 and t2.fld1=t3.t2nr and period = 1001 and t2.companynr = 37;fld1 fld3 period price price2018201 relaxing 1001 5987435 234724018601 vacuuming 1001 5987435 234724018801 inch 1001 5987435 234724018811 repetitions 1001 5987435 234724create table t4 (companynr tinyint(2) unsigned zerofill NOT NULL default '00',companyname char(30) NOT NULL default '',PRIMARY KEY (companynr),UNIQUE KEY companyname(companyname)) ENGINE=MyISAM MAX_ROWS=50 PACK_KEYS=1 COMMENT='companynames';select STRAIGHT_JOIN t2.companynr,companyname from t4,t2 where t2.companynr=t4.companynr group by t2.companynr;companynr companyname00 Unknown29 company 134 company 236 company 337 company 440 company 541 company 650 company 1153 company 758 company 865 company 968 company 10select SQL_SMALL_RESULT t2.companynr,companyname from t4,t2 where t2.companynr=t4.companynr group by t2.companynr;companynr companyname00 Unknown29 company 134 company 236 company 337 company 440 company 541 company 650 company 1153 company 758 company 865 company 968 company 10select * from t1,t1 t12;Period Varor_period Period Varor_period9410 9412 9410 9412select t2.fld1,t22.fld1 from t2,t2 t22 where t2.fld1 >= 250501 and t2.fld1 <= 250505 and t22.fld1 >= 250501 and t22.fld1 <= 250505;fld1 fld1250501 250501250502 250501250503 250501250504 250501250505 250501250501 250502250502 250502250503 250502250504 250502250505 250502250501 250503250502 250503250503 250503250504 250503250505 250503250501 250504250502 250504250503 250504250504 250504250505 250504250501 250505250502 250505250503 250505250504 250505250505 250505insert into t2 (fld1, companynr) values (999999,99);select t2.companynr,companyname from t2 left join t4 using (companynr) where t4.companynr is null;companynr companyname99 NULLselect count(*) from t2 left join t4 using (companynr) where t4.companynr is not null;count(*)1199explain select t2.companynr,companyname from t2 left join t4 using (companynr) where t4.companynr is null;id select_type table type possible_keys key key_len ref rows Extra1 SIMPLE t2 ALL NULL NULL NULL NULL 1200 1 SIMPLE t4 eq_ref PRIMARY PRIMARY 1 test.t2.companynr 1 Using where; Not existsexplain select t2.companynr,companyname from t4 left join t2 using (companynr) where t2.companynr is null;id select_type table type possible_keys key key_len ref rows Extra1 SIMPLE t4 ALL NULL NULL NULL NULL 12 1 SIMPLE t2 ALL NULL NULL NULL NULL 1200 Using where; Not existsselect companynr,companyname from t2 left join t4 using (companynr) where companynr is null;companynr companynameselect count(*) from t2 left join t4 using (companynr) where companynr is not null;count(*)1200explain select companynr,companyname from t2 left join t4 using (companynr) where companynr is null;id select_type table type possible_keys key key_len ref rows Extra1 SIMPLE NULL NULL NULL NULL NULL NULL NULL Impossible WHEREexplain select companynr,companyname from t4 left join t2 using (companynr) where companynr is null;id select_type table type possible_keys key key_len ref rows Extra1 SIMPLE NULL NULL NULL NULL NULL NULL NULL Impossible WHEREdelete from t2 where fld1=999999;explain select t2.companynr,companyname from t4 left join t2 using (companynr) where t2.companynr > 0;id select_type table type possible_keys key key_len ref rows Extra1 SIMPLE t2 ALL NULL NULL NULL NULL 1199 Using where1 SIMPLE t4 eq_ref PRIMARY PRIMARY 1 test.t2.companynr 1 explain select t2.companynr,companyname from t4 left join t2 using (companynr) where t2.companynr > 0 or t2.companynr < 0;id select_type table type possible_keys key key_len ref rows Extra1 SIMPLE t2 ALL NULL NULL NULL NULL 1199 Using where1 SIMPLE t4 eq_ref PRIMARY PRIMARY 1 test.t2.companynr 1 explain select t2.companynr,companyname from t4 left join t2 using (companynr) where t2.companynr > 0 and t4.companynr > 0;id select_type table type possible_keys key key_len ref rows Extra1 SIMPLE t2 ALL NULL NULL NULL NULL 1199 Using where1 SIMPLE t4 eq_ref PRIMARY PRIMARY 1 test.t2.companynr 1 explain select companynr,companyname from t4 left join t2 using (companynr) where companynr > 0;id select_type table type possible_keys key key_len ref rows Extra1 SIMPLE t4 ALL PRIMARY NULL NULL NULL 12 Using where1 SIMPLE t2 ALL NULL NULL NULL NULL 1199 explain select companynr,companyname from t4 left join t2 using (companynr) where companynr > 0 or companynr < 0;id select_type table type possible_keys key key_len ref rows Extra1 SIMPLE t4 ALL PRIMARY NULL NULL NULL 12 Using where1 SIMPLE t2 ALL NULL NULL NULL NULL 1199 explain select companynr,companyname from t4 left join t2 using (companynr) where companynr > 0 and companynr > 0;id select_type table type possible_keys key key_len ref rows Extra1 SIMPLE t4 ALL PRIMARY NULL NULL NULL 12 Using where1 SIMPLE t2 ALL NULL NULL NULL NULL 1199 explain select t2.companynr,companyname from t4 left join t2 using (companynr) where t2.companynr > 0 or t2.companynr is null;id select_type table type possible_keys key key_len ref rows Extra1 SIMPLE t4 ALL NULL NULL NULL NULL 12 1 SIMPLE t2 ALL NULL NULL NULL NULL 1199 Using whereexplain select t2.companynr,companyname from t4 left join t2 using (companynr) where t2.companynr > 0 or t2.companynr < 0 or t4.companynr > 0;id select_type table type possible_keys key key_len ref rows Extra1 SIMPLE t4 ALL PRIMARY NULL NULL NULL 12 1 SIMPLE t2 ALL NULL NULL NULL NULL 1199 Using whereexplain select t2.companynr,companyname from t4 left join t2 using (companynr) where ifnull(t2.companynr,1)>0;id select_type table type possible_keys key key_len ref rows Extra1 SIMPLE t4 ALL NULL NULL NULL NULL 12 1 SIMPLE t2 ALL NULL NULL NULL NULL 1199 Using whereexplain select companynr,companyname from t4 left join t2 using (companynr) where companynr > 0 or companynr is null;id select_type table type possible_keys key key_len ref rows Extra1 SIMPLE t4 ALL PRIMARY NULL NULL NULL 12 Using where1 SIMPLE t2 ALL NULL NULL NULL NULL 1199 explain select companynr,companyname from t4 left join t2 using (companynr) where companynr > 0 or companynr < 0 or companynr > 0;id select_type table type possible_keys key key_len ref rows Extra1 SIMPLE t4 ALL PRIMARY NULL NULL NULL 12 Using where1 SIMPLE t2 ALL NULL NULL NULL NULL 1199 explain select companynr,companyname from t4 left join t2 using (companynr) where ifnull(companynr,1)>0;id select_type table type possible_keys key key_len ref rows Extra1 SIMPLE t4 ALL NULL NULL NULL NULL 12 Using where1 SIMPLE t2 ALL NULL NULL NULL NULL 1199 select distinct t2.companynr,t4.companynr from t2,t4 where t2.companynr=t4.companynr+1;companynr companynr37 3641 40explain select distinct t2.companynr,t4.companynr from t2,t4 where t2.companynr=t4.companynr+1;id select_type table type possible_keys key key_len ref rows Extra1 SIMPLE t4 index NULL PRIMARY 1 NULL 12 Using index; Using temporary1 SIMPLE t2 ALL NULL NULL NULL NULL 1199 Using whereselect t2.fld1,t2.companynr,fld3,period from t3,t2 where t2.fld1 = 38208 and t2.fld1=t3.t2nr and period = 1008 or t2.fld1 = 38008 and t2.fld1 =t3.t2nr and period = 1008;fld1 companynr fld3 period038008 37 reporters 1008038208 37 Selfridge 1008select t2.fld1,t2.companynr,fld3,period from t3,t2 where (t2.fld1 = 38208 or t2.fld1 = 38008) and t2.fld1=t3.t2nr and period>=1008 and period<=1009;fld1 companynr fld3 period038008 37 reporters 1008038208 37 Selfridge 1008select t2.fld1,t2.companynr,fld3,period from t3,t2 where (t3.t2nr = 38208 or t3.t2nr = 38008) and t2.fld1=t3.t2nr and period>=1008 and period<=1009;fld1 companynr fld3 period038008 37 reporters 1008038208 37 Selfridge 1008select period from t1 where (((period > 0) or period < 10000 or (period = 1900)) and (period=1900 and period <= 1901) or (period=1903 and (period=1903)) and period>=1902) or ((period=1904 or period=1905) or (period=1906 or period>1907)) or (period=1908 and period = 1909);period9410select period from t1 where ((period > 0 and period < 1) or (((period > 0 and period < 100) and (period > 10)) or (period > 10)) or (period > 0 and (period > 5 or period > 6)));period9410select a.fld1 from t2 as a,t2 b where ((a.fld1 = 250501 and a.fld1=b.fld1) or a.fld1=250502 or a.fld1=250503 or (a.fld1=250505 and a.fld1<=b.fld1 and b.fld1>=a.fld1)) and a.fld1=b.fld1;fld1250501250502250503250505select fld1 from t2 where fld1 in (250502,98005,98006,250503,250605,250606) and fld1 >=250502 and fld1 not in (250605,250606);fld1250502250503select fld1 from t2 where fld1 between 250502 and 250504;fld1250502250503250504select fld3 from t2 where (((fld3 like "_%L%" ) or (fld3 like "%ok%")) and ( fld3 like "L%" or fld3 like "G%")) and fld3 like "L%" ;fld3labellabeledlabeledlandslidelaterallyleafletlewdlyLillianluckilyselect count(*) from t1;count(*)1select companynr,count(*),sum(fld1) from t2 group by companynr;companynr count(*) sum(fld1)00 82 1035575329 95 1447329834 70 1778896636 215 2278629637 588 8360209840 37 661838641 52 1281633550 11 159543853 4 79321058 23 225429365 10 228405568 12 3097288select companynr,count(*) from t2 group by companynr order by companynr desc limit 5;companynr count(*)68 1265 1058 2353 450 11select count(*),min(fld4),max(fld4),sum(fld1),avg(fld1),std(fld1),variance(fld1) from t2 where companynr = 34 and fld4<>"";count(*) min(fld4) max(fld4) sum(fld1) avg(fld1) std(fld1) variance(fld1)70 absentee vest 17788966 254128.0857 3272.5940 10709871.3069explain extended select count(*),min(fld4),max(fld4),sum(fld1),avg(fld1),std(fld1),variance(fld1) from t2 where companynr = 34 and fld4<>"";id select_type table type possible_keys key key_len ref rows Extra1 SIMPLE t2 ALL NULL NULL NULL NULL 1199 Using whereWarnings:Note 1003 select count(0) AS `count(*)`,min(`test`.`t2`.`fld4`) AS `min(fld4)`,max(`test`.`t2`.`fld4`) AS `max(fld4)`,sum(`test`.`t2`.`fld1`) AS `sum(fld1)`,avg(`test`.`t2`.`fld1`) AS `avg(fld1)`,std(`test`.`t2`.`fld1`) AS `std(fld1)`,variance(`test`.`t2`.`fld1`) AS `variance(fld1)` from `test`.`t2` where ((`test`.`t2`.`companynr` = 34) and (`test`.`t2`.`fld4` <> _latin1''))select companynr,count(*),min(fld4),max(fld4),sum(fld1),avg(fld1),std(fld1),variance(fld1) from t2 group by companynr limit 3;companynr count(*) min(fld4) max(fld4) sum(fld1) avg(fld1) std(fld1) variance(fld1)00 82 Anthony windmills 10355753 126289.6707 115550.9757 13352027981.708729 95 abut wetness 14473298 152350.5053 8368.5480 70032594.902634 70 absentee vest 17788966 254128.0857 3272.5940 10709871.3069select companynr,t2nr,count(price),sum(price),min(price),max(price),avg(price) from t3 where companynr = 37 group by companynr,t2nr limit 10;companynr t2nr count(price) sum(price) min(price) max(price) avg(price)37 1 1 5987435 5987435 5987435 5987435.000037 2 1 28357832 28357832 28357832 28357832.000037 3 1 39654943 39654943 39654943 39654943.000037 11 1 5987435 5987435 5987435 5987435.000037 12 1 28357832 28357832 28357832 28357832.000037 13 1 39654943 39654943 39654943 39654943.000037 21 1 5987435 5987435 5987435 5987435.000037 22 1 28357832 28357832 28357832 28357832.000037 23 1 39654943 39654943 39654943 39654943.000037 31 1 5987435 5987435 5987435 5987435.0000select /*! SQL_SMALL_RESULT */ companynr,t2nr,count(price),sum(price),min(price),max(price),avg(price) from t3 where companynr = 37 group by companynr,t2nr limit 10;companynr t2nr count(price) sum(price) min(price) max(price) avg(price)37 1 1 5987435 5987435 5987435 5987435.000037 2 1 28357832 28357832 28357832 28357832.000037 3 1 39654943 39654943 39654943 39654943.000037 11 1 5987435 5987435 5987435 5987435.000037 12 1 28357832 28357832 28357832 28357832.000037 13 1 39654943 39654943 39654943 39654943.000037 21 1 5987435 5987435 5987435 5987435.000037 22 1 28357832 28357832 28357832 28357832.000037 23 1 39654943 39654943 39654943 39654943.000037 31 1 5987435 5987435 5987435 5987435.0000select companynr,count(price),sum(price),min(price),max(price),avg(price) from t3 group by companynr ;companynr count(price) sum(price) min(price) max(price) avg(price)37 12543 309394878010 5987435 39654943 24666736.666778 8362 414611089292 726498 98439034 49582766.0000101 4181 3489454238 834598 834598 834598.0000154 4181 4112197254950 983543950 983543950 983543950.0000311 4181 979599938 234298 234298 234298.0000447 4181 9929180954 2374834 2374834 2374834.0000512 4181 3288532102 786542 786542 786542.0000select distinct mod(companynr,10) from t4 group by companynr;mod(companynr,10)094671385select distinct 1 from t4 group by companynr;11select count(distinct fld1) from t2;count(distinct fld1)1199select companynr,count(distinct fld1) from t2 group by companynr;companynr count(distinct fld1)00 8229 9534 7036 21537 58840 3741 5250 1153 458 2365 1068 12select companynr,count(*) from t2 group by companynr;companynr count(*)00 8229 9534 7036 21537 58840 3741 5250 1153 458 2365 1068 12select companynr,count(distinct concat(fld1,repeat(65,1000))) from t2 group by companynr;companynr count(distinct concat(fld1,repeat(65,1000)))00 8229 9534 7036 21537 58840 3741 5250 1153 458 2365 1068 12select companynr,count(distinct concat(fld1,repeat(65,200))) from t2 group by companynr;companynr count(distinct concat(fld1,repeat(65,200)))00 8229 9534 7036 21537 58840 3741 5250 1153 458 23⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -