📄 select.result
字号:
incorrectly 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 9410Hegelian 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:⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -