1SHOW STATUS LIKE 'Ssl_cipher'; 2Variable_name Value 3Ssl_cipher SSL_CIPHER 4SHOW STATUS LIKE 'Ssl_server_not_before'; 5Variable_name Value 6Ssl_server_not_before Dec 5 04:48:40 2014 GMT 7SHOW STATUS LIKE 'Ssl_server_not_after'; 8Variable_name Value 9Ssl_server_not_after Dec 1 04:48:40 2029 GMT 10drop table if exists t1,t2,t3,t4; 11CREATE TABLE t1 ( 12Period smallint(4) unsigned zerofill DEFAULT '0000' NOT NULL, 13Varor_period smallint(4) unsigned DEFAULT '0' NOT NULL 14); 15INSERT INTO t1 VALUES (9410,9412); 16select period from t1; 17period 189410 19select * from t1; 20Period Varor_period 219410 9412 22select t1.* from t1; 23Period Varor_period 249410 9412 25CREATE TABLE t2 ( 26auto int not null auto_increment, 27fld1 int(6) unsigned zerofill DEFAULT '000000' NOT NULL, 28companynr tinyint(2) unsigned zerofill DEFAULT '00' NOT NULL, 29fld3 char(30) DEFAULT '' NOT NULL, 30fld4 char(35) DEFAULT '' NOT NULL, 31fld5 char(35) DEFAULT '' NOT NULL, 32fld6 char(4) DEFAULT '' NOT NULL, 33UNIQUE fld1 (fld1), 34KEY fld3 (fld3), 35PRIMARY KEY (auto) 36); 37select t2.fld3 from t2 where companynr = 58 and fld3 like "%imaginable%"; 38fld3 39imaginable 40select fld3 from t2 where fld3 like "%cultivation" ; 41fld3 42cultivation 43select t2.fld3,companynr from t2 where companynr = 57+1 order by fld3; 44fld3 companynr 45concoct 58 46druggists 58 47engrossing 58 48Eurydice 58 49exclaimers 58 50ferociousness 58 51hopelessness 58 52Huey 58 53imaginable 58 54judges 58 55merging 58 56ostrich 58 57peering 58 58Phelps 58 59presumes 58 60Ruth 58 61sentences 58 62Shylock 58 63straggled 58 64synergy 58 65thanking 58 66tying 58 67unlocks 58 68select fld3,companynr from t2 where companynr = 58 order by fld3; 69fld3 companynr 70concoct 58 71druggists 58 72engrossing 58 73Eurydice 58 74exclaimers 58 75ferociousness 58 76hopelessness 58 77Huey 58 78imaginable 58 79judges 58 80merging 58 81ostrich 58 82peering 58 83Phelps 58 84presumes 58 85Ruth 58 86sentences 58 87Shylock 58 88straggled 58 89synergy 58 90thanking 58 91tying 58 92unlocks 58 93select fld3 from t2 order by fld3 desc limit 10; 94fld3 95youthfulness 96yelped 97Wotan 98workers 99Witt 100witchcraft 101Winsett 102Willy 103willed 104wildcats 105select fld3 from t2 order by fld3 desc limit 5; 106fld3 107youthfulness 108yelped 109Wotan 110workers 111Witt 112select fld3 from t2 order by fld3 desc limit 5,5; 113fld3 114witchcraft 115Winsett 116Willy 117willed 118wildcats 119select t2.fld3 from t2 where fld3 = 'honeysuckle'; 120fld3 121honeysuckle 122select t2.fld3 from t2 where fld3 LIKE 'honeysuckl_'; 123fld3 124honeysuckle 125select t2.fld3 from t2 where fld3 LIKE 'hon_ysuckl_'; 126fld3 127honeysuckle 128select t2.fld3 from t2 where fld3 LIKE 'honeysuckle%'; 129fld3 130honeysuckle 131select t2.fld3 from t2 where fld3 LIKE 'h%le'; 132fld3 133honeysuckle 134select t2.fld3 from t2 where fld3 LIKE 'honeysuckle_'; 135fld3 136select t2.fld3 from t2 where fld3 LIKE 'don_t_find_me_please%'; 137fld3 138explain select t2.fld3 from t2 where fld3 = 'honeysuckle'; 139id select_type table type possible_keys key key_len ref rows Extra 1401 SIMPLE t2 ref fld3 fld3 30 const 1 Using where; Using index 141explain select fld3 from t2 ignore index (fld3) where fld3 = 'honeysuckle'; 142id select_type table type possible_keys key key_len ref rows Extra 1431 SIMPLE t2 ALL NULL NULL NULL NULL 1199 Using where 144explain select fld3 from t2 use index (fld1) where fld3 = 'honeysuckle'; 145id select_type table type possible_keys key key_len ref rows Extra 1461 SIMPLE t2 ALL NULL NULL NULL NULL 1199 Using where 147explain select fld3 from t2 use index (fld3) where fld3 = 'honeysuckle'; 148id select_type table type possible_keys key key_len ref rows Extra 1491 SIMPLE t2 ref fld3 fld3 30 const 1 Using where; Using index 150explain select fld3 from t2 use index (fld1,fld3) where fld3 = 'honeysuckle'; 151id select_type table type possible_keys key key_len ref rows Extra 1521 SIMPLE t2 ref fld3 fld3 30 const 1 Using where; Using index 153explain select fld3 from t2 ignore index (fld3,not_used); 154ERROR 42000: Key 'not_used' doesn't exist in table 't2' 155explain select fld3 from t2 use index (not_used); 156ERROR 42000: Key 'not_used' doesn't exist in table 't2' 157select t2.fld3 from t2 where fld3 >= 'honeysuckle' and fld3 <= 'honoring' order by fld3; 158fld3 159honeysuckle 160honoring 161explain select t2.fld3 from t2 where fld3 >= 'honeysuckle' and fld3 <= 'honoring' order by fld3; 162id select_type table type possible_keys key key_len ref rows Extra 1631 SIMPLE t2 range fld3 fld3 30 NULL 2 Using where; Using index 164select fld1,fld3 from t2 where fld3="Colombo" or fld3 = "nondecreasing" order by fld3; 165fld1 fld3 166148504 Colombo 167068305 Colombo 168000000 nondecreasing 169select fld1,fld3 from t2 where companynr = 37 and fld3 = 'appendixes'; 170fld1 fld3 171232605 appendixes 1721232605 appendixes 1731232606 appendixes 1741232607 appendixes 1751232608 appendixes 1761232609 appendixes 177select fld1 from t2 where fld1=250501 or fld1="250502"; 178fld1 179250501 180250502 181explain select fld1 from t2 where fld1=250501 or fld1="250502"; 182id select_type table type possible_keys key key_len ref rows Extra 1831 SIMPLE t2 range fld1 fld1 4 NULL 2 Using where; Using index 184select fld1 from t2 where fld1=250501 or fld1=250502 or fld1 >= 250505 and fld1 <= 250601 or fld1 between 250501 and 250502; 185fld1 186250501 187250502 188250505 189250601 190explain select fld1 from t2 where fld1=250501 or fld1=250502 or fld1 >= 250505 and fld1 <= 250601 or fld1 between 250501 and 250502; 191id select_type table type possible_keys key key_len ref rows Extra 1921 SIMPLE t2 range fld1 fld1 4 NULL 4 Using where; Using index 193select fld1,fld3 from t2 where companynr = 37 and fld3 like 'f%'; 194fld1 fld3 195012001 flanking 196013602 foldout 197013606 fingerings 198018007 fanatic 199018017 featherweight 200018054 fetters 201018103 flint 202018104 flopping 203036002 funereal 204038017 fetched 205038205 firearm 206058004 Fenton 207088303 feminine 208186002 freakish 209188007 flurried 210188505 fitting 211198006 furthermore 212202301 Fitzpatrick 213208101 fiftieth 214208113 freest 215218008 finishers 216218022 feed 217218401 faithful 218226205 foothill 219226209 furnishings 220228306 forthcoming 221228311 fated 222231315 freezes 223232102 forgivably 224238007 filial 225238008 fixedly 226select fld3 from t2 where fld3 like "L%" and fld3 = "ok"; 227fld3 228select fld3 from t2 where (fld3 like "C%" and fld3 = "Chantilly"); 229fld3 230Chantilly 231select fld1,fld3 from t2 where fld1 like "25050%"; 232fld1 fld3 233250501 poisoning 234250502 Iraqis 235250503 heaving 236250504 population 237250505 bomb 238select fld1,fld3 from t2 where fld1 like "25050_"; 239fld1 fld3 240250501 poisoning 241250502 Iraqis 242250503 heaving 243250504 population 244250505 bomb 245select distinct companynr from t2; 246companynr 24700 24837 24936 25050 25158 25229 25340 25453 25565 25641 25734 25868 259select distinct companynr from t2 order by companynr; 260companynr 26100 26229 26334 26436 26537 26640 26741 26850 26953 27058 27165 27268 273select distinct companynr from t2 order by companynr desc; 274companynr 27568 27665 27758 27853 27950 28041 28140 28237 28336 28434 28529 28600 287select distinct t2.fld3,period from t2,t1 where companynr=37 and fld3 like "O%"; 288fld3 period 289obliterates 9410 290offload 9410 291opaquely 9410 292organizer 9410 293overestimating 9410 294overlay 9410 295select distinct fld3 from t2 where companynr = 34 order by fld3; 296fld3 297absentee 298accessed 299ahead 300alphabetic 301Asiaticizations 302attitude 303aye 304bankruptcies 305belays 306Blythe 307bomb 308boulevard 309bulldozes 310cannot 311caressing 312charcoal 313checksumming 314chess 315clubroom 316colorful 317cosy 318creator 319crying 320Darius 321diffusing 322duality 323Eiffel 324Epiphany 325Ernestine 326explorers 327exterminated 328famine 329forked 330Gershwins 331heaving 332Hodges 333Iraqis 334Italianization 335Lagos 336landslide 337libretto 338Majorca 339mastering 340narrowed 341occurred 342offerers 343Palestine 344Peruvianizes 345pharmaceutic 346poisoning 347population 348Pygmalion 349rats 350realest 351recording 352regimented 353retransmitting 354reviver 355rouses 356scars 357sicker 358sleepwalk 359stopped 360sugars 361translatable 362uncles 363unexpected 364uprisings 365versatility 366vest 367select distinct fld3 from t2 limit 10; 368fld3 369abates 370abiding 371Abraham 372abrogating 373absentee 374abut 375accessed 376accruing 377accumulating 378accuracies 379select distinct fld3 from t2 having fld3 like "A%" limit 10; 380fld3 381abates 382abiding 383Abraham 384abrogating 385absentee 386abut 387accessed 388accruing 389accumulating 390accuracies 391select distinct substring(fld3,1,3) from t2 where fld3 like "A%"; 392substring(fld3,1,3) 393aba 394abi 395Abr 396abs 397abu 398acc 399acq 400acu 401Ade 402adj 403Adl 404adm 405Ado 406ads 407adv 408aer 409aff 410afi 411afl 412afo 413agi 414ahe 415aim 416air 417Ald 418alg 419ali 420all 421alp 422alr 423ama 424ame 425amm 426ana 427and 428ane 429Ang 430ani 431Ann 432Ant 433api 434app 435aqu 436Ara 437arc 438Arm 439arr 440Art 441Asi 442ask 443asp 444ass 445ast 446att 447aud 448Aug 449aut 450ave 451avo 452awe 453aye 454Azt 455select distinct substring(fld3,1,3) as a from t2 having a like "A%" order by a limit 10; 456a 457aba 458abi 459Abr 460abs 461abu 462acc 463acq 464acu 465Ade 466adj 467select distinct substring(fld3,1,3) from t2 where fld3 like "A%" limit 10; 468substring(fld3,1,3) 469aba 470abi 471Abr 472abs 473abu 474acc 475acq 476acu 477Ade 478adj 479select distinct substring(fld3,1,3) as a from t2 having a like "A%" limit 10; 480a 481aba 482abi 483Abr 484abs 485abu 486acc 487acq 488acu 489Ade 490adj 491create table t3 ( 492period int not null, 493name char(32) not null, 494companynr int not null, 495price double(11,0), 496price2 double(11,0), 497key (period), 498key (name) 499); 500create temporary table tmp engine = myisam select * from t3; 501insert into t3 select * from tmp; 502insert into tmp select * from t3; 503insert into t3 select * from tmp; 504insert into tmp select * from t3; 505insert into t3 select * from tmp; 506insert into tmp select * from t3; 507insert into t3 select * from tmp; 508insert into tmp select * from t3; 509insert into t3 select * from tmp; 510insert into tmp select * from t3; 511insert into t3 select * from tmp; 512insert into tmp select * from t3; 513insert into t3 select * from tmp; 514insert into tmp select * from t3; 515insert into t3 select * from tmp; 516insert into tmp select * from t3; 517insert into t3 select * from tmp; 518alter table t3 add t2nr int not null auto_increment primary key first; 519drop table tmp; 520SET BIG_TABLES=1; 521select distinct concat(fld3," ",fld3) as namn from t2,t3 where t2.fld1=t3.t2nr order by namn limit 10; 522namn 523Abraham Abraham 524abrogating abrogating 525admonishing admonishing 526Adolph Adolph 527afield afield 528aging aging 529ammonium ammonium 530analyzable analyzable 531animals animals 532animized animized 533SET BIG_TABLES=0; 534select distinct concat(fld3," ",fld3) from t2,t3 where t2.fld1=t3.t2nr order by fld3 limit 10; 535concat(fld3," ",fld3) 536Abraham Abraham 537abrogating abrogating 538admonishing admonishing 539Adolph Adolph 540afield afield 541aging aging 542ammonium ammonium 543analyzable analyzable 544animals animals 545animized animized 546select distinct fld5 from t2 limit 10; 547fld5 548neat 549Steinberg 550jarring 551tinily 552balled 553persist 554attainments 555fanatic 556measures 557rightfulness 558select distinct fld3,count(*) from t2 group by companynr,fld3 limit 10; 559fld3 count(*) 560affixed 1 561and 1 562annoyers 1 563Anthony 1 564assayed 1 565assurers 1 566attendants 1 567bedlam 1 568bedpost 1 569boasted 1 570SET BIG_TABLES=1; 571select distinct fld3,count(*) from t2 group by companynr,fld3 limit 10; 572fld3 count(*) 573affixed 1 574and 1 575annoyers 1 576Anthony 1 577assayed 1 578assurers 1 579attendants 1 580bedlam 1 581bedpost 1 582boasted 1 583SET BIG_TABLES=0; 584select distinct fld3,repeat("a",length(fld3)),count(*) from t2 group by companynr,fld3 limit 100,10; 585fld3 repeat("a",length(fld3)) count(*) 586circus aaaaaa 1 587cited aaaaa 1 588Colombo aaaaaaa 1 589congresswoman aaaaaaaaaaaaa 1 590contrition aaaaaaaaaa 1 591corny aaaaa 1 592cultivation aaaaaaaaaaa 1 593definiteness aaaaaaaaaaaa 1 594demultiplex aaaaaaaaaaa 1 595disappointing aaaaaaaaaaaaa 1 596select distinct companynr,rtrim(space(512+companynr)) from t3 order by 1,2; 597companynr rtrim(space(512+companynr)) 59837 59978 600101 601154 602311 603447 604512 605select distinct fld3 from t2,t3 where t2.companynr = 34 and t2.fld1=t3.t2nr order by fld3; 606fld3 607explain select t3.t2nr,fld3 from t2,t3 where t2.companynr = 34 and t2.fld1=t3.t2nr order by t3.t2nr,fld3; 608id select_type table type possible_keys key key_len ref rows Extra 6091 SIMPLE t2 ALL fld1 NULL NULL NULL 1199 Using where; Using temporary; Using filesort 6101 SIMPLE t3 eq_ref PRIMARY PRIMARY 4 test.t2.fld1 1 Using where; Using index 611explain select * from t3 as t1,t3 where t1.period=t3.period order by t3.period; 612id select_type table type possible_keys key key_len ref rows Extra 6131 SIMPLE t1 ALL period NULL NULL NULL 41810 Using temporary; Using filesort 6141 SIMPLE t3 ref period period 4 test.t1.period 4181 NULL 615explain select * from t3 as t1,t3 where t1.period=t3.period order by t3.period limit 10; 616id select_type table type possible_keys key key_len ref rows Extra 6171 SIMPLE t3 index period period 4 NULL 1 NULL 6181 SIMPLE t1 ref period period 4 test.t3.period 4181 NULL 619explain select * from t3 as t1,t3 where t1.period=t3.period order by t1.period limit 10; 620id select_type table type possible_keys key key_len ref rows Extra 6211 SIMPLE t1 index period period 4 NULL 1 NULL 6221 SIMPLE t3 ref period period 4 test.t1.period 4181 NULL 623select period from t1; 624period 6259410 626select period from t1 where period=1900; 627period 628select fld3,period from t1,t2 where fld1 = 011401 order by period; 629fld3 period 630breaking 9410 631select fld3,period from t2,t3 where t2.fld1 = 011401 and t2.fld1=t3.t2nr and t3.period=1001; 632fld3 period 633breaking 1001 634explain select fld3,period from t2,t3 where t2.fld1 = 011401 and t3.t2nr=t2.fld1 and 1001 = t3.period; 635id select_type table type possible_keys key key_len ref rows Extra 6361 SIMPLE t2 const fld1 fld1 4 const 1 NULL 6371 SIMPLE t3 const PRIMARY,period PRIMARY 4 const 1 NULL 638select fld3,period from t2,t1 where companynr*10 = 37*10; 639fld3 period 640breaking 9410 641Romans 9410 642intercepted 9410 643bewilderingly 9410 644astound 9410 645admonishing 9410 646sumac 9410 647flanking 9410 648combed 9410 649subjective 9410 650scatterbrain 9410 651Eulerian 9410 652Kane 9410 653overlay 9410 654perturb 9410 655goblins 9410 656annihilates 9410 657Wotan 9410 658snatching 9410 659concludes 9410 660laterally 9410 661yelped 9410 662grazing 9410 663Baird 9410 664celery 9410 665misunderstander 9410 666handgun 9410 667foldout 9410 668mystic 9410 669succumbed 9410 670Nabisco 9410 671fingerings 9410 672aging 9410 673afield 9410 674ammonium 9410 675boat 9410 676intelligibility 9410 677Augustine 9410 678teethe 9410 679dreaded 9410 680scholastics 9410 681audiology 9410 682wallet 9410 683parters 9410 684eschew 9410 685quitter 9410 686neat 9410 687Steinberg 9410 688jarring 9410 689tinily 9410 690balled 9410 691persist 9410 692attainments 9410 693fanatic 9410 694measures 9410 695rightfulness 9410 696capably 9410 697impulsive 9410 698starlet 9410 699terminators 9410 700untying 9410 701announces 9410 702featherweight 9410 703pessimist 9410 704daughter 9410 705decliner 9410 706lawgiver 9410 707stated 9410 708readable 9410 709attrition 9410 710cascade 9410 711motors 9410 712interrogate 9410 713pests 9410 714stairway 9410 715dopers 9410 716testicle 9410 717Parsifal 9410 718leavings 9410 719postulation 9410 720squeaking 9410 721contrasted 9410 722leftover 9410 723whiteners 9410 724erases 9410 725Punjab 9410 726Merritt 9410 727Quixotism 9410 728sweetish 9410 729dogging 9410 730scornfully 9410 731bellow 9410 732bills 9410 733cupboard 9410 734sureties 9410 735puddings 9410 736fetters 9410 737bivalves 9410 738incurring 9410 739Adolph 9410 740pithed 9410 741Miles 9410 742trimmings 9410 743tragedies 9410 744skulking 9410 745flint 9410 746flopping 9410 747relaxing 9410 748offload 9410 749suites 9410 750lists 9410 751animized 9410 752multilayer 9410 753standardizes 9410 754Judas 9410 755vacuuming 9410 756dentally 9410 757humanness 9410 758inch 9410 759Weissmuller 9410 760irresponsibly 9410 761luckily 9410 762culled 9410 763medical 9410 764bloodbath 9410 765subschema 9410 766animals 9410 767Micronesia 9410 768repetitions 9410 769Antares 9410 770ventilate 9410 771pityingly 9410 772interdependent 9410 773Graves 9410 774neonatal 9410 775chafe 9410 776honoring 9410 777realtor 9410 778elite 9410 779funereal 9410 780abrogating 9410 781sorters 9410 782Conley 9410 783lectured 9410 784Abraham 9410 785Hawaii 9410 786cage 9410 787hushes 9410 788Simla 9410 789reporters 9410 790Dutchman 9410 791descendants 9410 792groupings 9410 793dissociate 9410 794coexist 9410 795Beebe 9410 796Taoism 9410 797Connally 9410 798fetched 9410 799checkpoints 9410 800rusting 9410 801galling 9410 802obliterates 9410 803traitor 9410 804resumes 9410 805analyzable 9410 806terminator 9410 807gritty 9410 808firearm 9410 809minima 9410 810Selfridge 9410 811disable 9410 812witchcraft 9410 813betroth 9410 814Manhattanize 9410 815imprint 9410 816peeked 9410 817swelling 9410 818interrelationships 9410 819riser 9410 820Gandhian 9410 821peacock 9410 822bee 9410 823kanji 9410 824dental 9410 825scarf 9410 826chasm 9410 827insolence 9410 828syndicate 9410 829alike 9410 830imperial 9410 831convulsion 9410 832railway 9410 833validate 9410 834normalizes 9410 835comprehensive 9410 836chewing 9410 837denizen 9410 838schemer 9410 839chronicle 9410 840Kline 9410 841Anatole 9410 842partridges 9410 843brunch 9410 844recruited 9410 845dimensions 9410 846Chicana 9410 847announced 9410 848praised 9410 849employing 9410 850linear 9410 851quagmire 9410 852western 9410 853relishing 9410 854serving 9410 855scheduling 9410 856lore 9410 857eventful 9410 858arteriole 9410 859disentangle 9410 860cured 9410 861Fenton 9410 862avoidable 9410 863drains 9410 864detectably 9410 865husky 9410 866impelling 9410 867undoes 9410 868evened 9410 869squeezes 9410 870destroyer 9410 871rudeness 9410 872beaner 9410 873boorish 9410 874Everhart 9410 875encompass 9410 876mushrooms 9410 877Alison 9410 878externally 9410 879pellagra 9410 880cult 9410 881creek 9410 882Huffman 9410 883Majorca 9410 884governing 9410 885gadfly 9410 886reassigned 9410 887intentness 9410 888craziness 9410 889psychic 9410 890squabbled 9410 891burlesque 9410 892capped 9410 893extracted 9410 894DiMaggio 9410 895exclamation 9410 896subdirectory 9410 897Gothicism 9410 898feminine 9410 899metaphysically 9410 900sanding 9410 901Miltonism 9410 902freakish 9410 903index 9410 904straight 9410 905flurried 9410 906denotative 9410 907coming 9410 908commencements 9410 909gentleman 9410 910gifted 9410 911Shanghais 9410 912sportswriting 9410 913sloping 9410 914navies 9410 915leaflet 9410 916shooter 9410 917Joplin 9410 918babies 9410 919assails 9410 920admiring 9410 921swaying 9410 922Goldstine 9410 923fitting 9410 924Norwalk 9410 925analogy 9410 926deludes 9410 927cokes 9410 928Clayton 9410 929exhausts 9410 930causality 9410 931sating 9410 932icon 9410 933throttles 9410 934communicants 9410 935dehydrate 9410 936priceless 9410 937publicly 9410 938incidentals 9410 939commonplace 9410 940mumbles 9410 941furthermore 9410 942cautioned 9410 943parametrized 9410 944registration 9410 945sadly 9410 946positioning 9410 947babysitting 9410 948eternal 9410 949hoarder 9410 950congregates 9410 951rains 9410 952workers 9410 953sags 9410 954unplug 9410 955garage 9410 956boulder 9410 957specifics 9410 958Teresa 9410 959Winsett 9410 960convenient 9410 961buckboards 9410 962amenities 9410 963resplendent 9410 964sews 9410 965participated 9410 966Simon 9410 967certificates 9410 968Fitzpatrick 9410 969Evanston 9410 970misted 9410 971textures 9410 972save 9410 973count 9410 974rightful 9410 975chaperone 9410 976Lizzy 9410 977clenched 9410 978effortlessly 9410 979accessed 9410 980beaters 9410 981Hornblower 9410 982vests 9410 983indulgences 9410 984infallibly 9410 985unwilling 9410 986excrete 9410 987spools 9410 988crunches 9410 989overestimating 9410 990ineffective 9410 991humiliation 9410 992sophomore 9410 993star 9410 994rifles 9410 995dialysis 9410 996arriving 9410 997indulge 9410 998clockers 9410 999languages 9410 1000Antarctica 9410 1001percentage 9410 1002ceiling 9410 1003specification 9410 1004regimented 9410 1005ciphers 9410 1006pictures 9410 1007serpents 9410 1008allot 9410 1009realized 9410 1010mayoral 9410 1011opaquely 9410 1012hostess 9410 1013fiftieth 9410 1014incorrectly 9410 1015decomposition 9410 1016stranglings 9410 1017mixture 9410 1018electroencephalography 9410 1019similarities 9410 1020charges 9410 1021freest 9410 1022Greenberg 9410 1023tinting 9410 1024expelled 9410 1025warm 9410 1026smoothed 9410 1027deductions 9410 1028Romano 9410 1029bitterroot 9410 1030corset 9410 1031securing 9410 1032environing 9410 1033cute 9410 1034Crays 9410 1035heiress 9410 1036inform 9410 1037avenge 9410 1038universals 9410 1039Kinsey 9410 1040ravines 9410 1041bestseller 9410 1042equilibrium 9410 1043extents 9410 1044relatively 9410 1045pressure 9410 1046critiques 9410 1047befouled 9410 1048rightfully 9410 1049mechanizing 9410 1050Latinizes 9410 1051timesharing 9410 1052Aden 9410 1053embassies 9410 1054males 9410 1055shapelessly 9410 1056mastering 9410 1057Newtonian 9410 1058finishers 9410 1059abates 9410 1060teem 9410 1061kiting 9410 1062stodgy 9410 1063feed 9410 1064guitars 9410 1065airships 9410 1066store 9410 1067denounces 9410 1068Pyle 9410 1069Saxony 9410 1070serializations 9410 1071Peruvian 9410 1072taxonomically 9410 1073kingdom 9410 1074stint 9410 1075Sault 9410 1076faithful 9410 1077Ganymede 9410 1078tidiness 9410 1079gainful 9410 1080contrary 9410 1081Tipperary 9410 1082tropics 9410 1083theorizers 9410 1084renew 9410 1085already 9410 1086terminal 9410 1087Hegelian 9410 1088hypothesizer 9410 1089warningly 9410 1090journalizing 9410 1091nested 9410 1092Lars 9410 1093saplings 9410 1094foothill 9410 1095labeled 9410 1096imperiously 9410 1097reporters 9410 1098furnishings 9410 1099precipitable 9410 1100discounts 9410 1101excises 9410 1102Stalin 9410 1103despot 9410 1104ripeness 9410 1105Arabia 9410 1106unruly 9410 1107mournfulness 9410 1108boom 9410 1109slaughter 9410 1110Sabine 9410 1111handy 9410 1112rural 9410 1113organizer 9410 1114shipyard 9410 1115civics 9410 1116inaccuracy 9410 1117rules 9410 1118juveniles 9410 1119comprised 9410 1120investigations 9410 1121stabilizes 9410 1122seminaries 9410 1123Hunter 9410 1124sporty 9410 1125test 9410 1126weasels 9410 1127CERN 9410 1128tempering 9410 1129afore 9410 1130Galatean 9410 1131techniques 9410 1132error 9410 1133veranda 9410 1134severely 9410 1135Cassites 9410 1136forthcoming 9410 1137guides 9410 1138vanish 9410 1139lied 9410 1140sawtooth 9410 1141fated 9410 1142gradually 9410 1143widens 9410 1144preclude 9410 1145evenhandedly 9410 1146percentage 9410 1147disobedience 9410 1148humility 9410 1149gleaning 9410 1150petted 9410 1151bloater 9410 1152minion 9410 1153marginal 9410 1154apiary 9410 1155measures 9410 1156precaution 9410 1157repelled 9410 1158primary 9410 1159coverings 9410 1160Artemia 9410 1161navigate 9410 1162spatial 9410 1163Gurkha 9410 1164meanwhile 9410 1165Melinda 9410 1166Butterfield 9410 1167Aldrich 9410 1168previewing 9410 1169glut 9410 1170unaffected 9410 1171inmate 9410 1172mineral 9410 1173impending 9410 1174meditation 9410 1175ideas 9410 1176miniaturizes 9410 1177lewdly 9410 1178title 9410 1179youthfulness 9410 1180creak 9410 1181Chippewa 9410 1182clamored 9410 1183freezes 9410 1184forgivably 9410 1185reduce 9410 1186McGovern 9410 1187Nazis 9410 1188epistle 9410 1189socializes 9410 1190conceptions 9410 1191Kevin 9410 1192uncovering 9410 1193chews 9410 1194appendixes 9410 1195appendixes 9410 1196appendixes 9410 1197appendixes 9410 1198appendixes 9410 1199appendixes 9410 1200raining 9410 1201infest 9410 1202compartment 9410 1203minting 9410 1204ducks 9410 1205roped 9410 1206waltz 9410 1207Lillian 9410 1208repressions 9410 1209chillingly 9410 1210noncritical 9410 1211lithograph 9410 1212spongers 9410 1213parenthood 9410 1214posed 9410 1215instruments 9410 1216filial 9410 1217fixedly 9410 1218relives 9410 1219Pandora 9410 1220watering 9410 1221ungrateful 9410 1222secures 9410 1223poison 9410 1224dusted 9410 1225encompasses 9410 1226presentation 9410 1227Kantian 9410 1228select 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; 1229fld3 period price price2 1230admonishing 1002 28357832 8723648 1231analyzable 1002 28357832 8723648 1232annihilates 1001 5987435 234724 1233Antares 1002 28357832 8723648 1234astound 1001 5987435 234724 1235audiology 1001 5987435 234724 1236Augustine 1002 28357832 8723648 1237Baird 1002 28357832 8723648 1238bewilderingly 1001 5987435 234724 1239breaking 1001 5987435 234724 1240Conley 1001 5987435 234724 1241dentally 1002 28357832 8723648 1242dissociate 1002 28357832 8723648 1243elite 1001 5987435 234724 1244eschew 1001 5987435 234724 1245Eulerian 1001 5987435 234724 1246flanking 1001 5987435 234724 1247foldout 1002 28357832 8723648 1248funereal 1002 28357832 8723648 1249galling 1002 28357832 8723648 1250Graves 1001 5987435 234724 1251grazing 1001 5987435 234724 1252groupings 1001 5987435 234724 1253handgun 1001 5987435 234724 1254humility 1002 28357832 8723648 1255impulsive 1002 28357832 8723648 1256inch 1001 5987435 234724 1257intelligibility 1001 5987435 234724 1258jarring 1001 5987435 234724 1259lawgiver 1001 5987435 234724 1260lectured 1002 28357832 8723648 1261Merritt 1002 28357832 8723648 1262neonatal 1001 5987435 234724 1263offload 1002 28357832 8723648 1264parters 1002 28357832 8723648 1265pityingly 1002 28357832 8723648 1266puddings 1002 28357832 8723648 1267Punjab 1001 5987435 234724 1268quitter 1002 28357832 8723648 1269realtor 1001 5987435 234724 1270relaxing 1001 5987435 234724 1271repetitions 1001 5987435 234724 1272resumes 1001 5987435 234724 1273Romans 1002 28357832 8723648 1274rusting 1001 5987435 234724 1275scholastics 1001 5987435 234724 1276skulking 1002 28357832 8723648 1277stated 1002 28357832 8723648 1278suites 1002 28357832 8723648 1279sureties 1001 5987435 234724 1280testicle 1002 28357832 8723648 1281tinily 1002 28357832 8723648 1282tragedies 1001 5987435 234724 1283trimmings 1001 5987435 234724 1284vacuuming 1001 5987435 234724 1285ventilate 1001 5987435 234724 1286wallet 1001 5987435 234724 1287Weissmuller 1002 28357832 8723648 1288Wotan 1002 28357832 8723648 1289select 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; 1290fld1 fld3 period price price2 1291018201 relaxing 1001 5987435 234724 1292018601 vacuuming 1001 5987435 234724 1293018801 inch 1001 5987435 234724 1294018811 repetitions 1001 5987435 234724 1295create table t4 ( 1296companynr tinyint(2) unsigned zerofill NOT NULL default '00', 1297companyname char(30) NOT NULL default '', 1298PRIMARY KEY (companynr), 1299UNIQUE KEY companyname(companyname) 1300) ENGINE=MyISAM MAX_ROWS=50 PACK_KEYS=1 COMMENT='companynames'; 1301select STRAIGHT_JOIN t2.companynr,companyname from t4,t2 where t2.companynr=t4.companynr group by t2.companynr; 1302companynr companyname 130300 Unknown 130429 company 1 130534 company 2 130636 company 3 130737 company 4 130840 company 5 130941 company 6 131050 company 11 131153 company 7 131258 company 8 131365 company 9 131468 company 10 1315select SQL_SMALL_RESULT t2.companynr,companyname from t4,t2 where t2.companynr=t4.companynr group by t2.companynr; 1316companynr companyname 131700 Unknown 131829 company 1 131934 company 2 132036 company 3 132137 company 4 132240 company 5 132341 company 6 132450 company 11 132553 company 7 132658 company 8 132765 company 9 132868 company 10 1329select * from t1,t1 t12; 1330Period Varor_period Period Varor_period 13319410 9412 9410 9412 1332select t2.fld1,t22.fld1 from t2,t2 t22 where t2.fld1 >= 250501 and t2.fld1 <= 250505 and t22.fld1 >= 250501 and t22.fld1 <= 250505; 1333fld1 fld1 1334250501 250501 1335250502 250501 1336250503 250501 1337250504 250501 1338250505 250501 1339250501 250502 1340250502 250502 1341250503 250502 1342250504 250502 1343250505 250502 1344250501 250503 1345250502 250503 1346250503 250503 1347250504 250503 1348250505 250503 1349250501 250504 1350250502 250504 1351250503 250504 1352250504 250504 1353250505 250504 1354250501 250505 1355250502 250505 1356250503 250505 1357250504 250505 1358250505 250505 1359insert into t2 (fld1, companynr) values (999999,99); 1360select t2.companynr,companyname from t2 left join t4 using (companynr) where t4.companynr is null; 1361companynr companyname 136299 NULL 1363select count(*) from t2 left join t4 using (companynr) where t4.companynr is not null; 1364count(*) 13651199 1366explain select t2.companynr,companyname from t2 left join t4 using (companynr) where t4.companynr is null; 1367id select_type table type possible_keys key key_len ref rows Extra 13681 SIMPLE t2 ALL NULL NULL NULL NULL 1200 NULL 13691 SIMPLE t4 eq_ref PRIMARY PRIMARY 1 test.t2.companynr 1 Using where; Not exists 1370explain select t2.companynr,companyname from t4 left join t2 using (companynr) where t2.companynr is null; 1371id select_type table type possible_keys key key_len ref rows Extra 13721 SIMPLE t4 ALL NULL NULL NULL NULL 12 NULL 13731 SIMPLE t2 ALL NULL NULL NULL NULL 1200 Using where; Not exists; Using join buffer (Block Nested Loop) 1374select companynr,companyname from t2 left join t4 using (companynr) where companynr is null; 1375companynr companyname 1376select count(*) from t2 left join t4 using (companynr) where companynr is not null; 1377count(*) 13781200 1379explain select companynr,companyname from t2 left join t4 using (companynr) where companynr is null; 1380id select_type table type possible_keys key key_len ref rows Extra 13811 SIMPLE NULL NULL NULL NULL NULL NULL NULL Impossible WHERE 1382explain select companynr,companyname from t4 left join t2 using (companynr) where companynr is null; 1383id select_type table type possible_keys key key_len ref rows Extra 13841 SIMPLE NULL NULL NULL NULL NULL NULL NULL Impossible WHERE 1385delete from t2 where fld1=999999; 1386explain select t2.companynr,companyname from t4 left join t2 using (companynr) where t2.companynr > 0; 1387id select_type table type possible_keys key key_len ref rows Extra 13881 SIMPLE t2 ALL NULL NULL NULL NULL 1199 Using where 13891 SIMPLE t4 eq_ref PRIMARY PRIMARY 1 test.t2.companynr 1 NULL 1390explain select t2.companynr,companyname from t4 left join t2 using (companynr) where t2.companynr > 0 or t2.companynr < 0; 1391id select_type table type possible_keys key key_len ref rows Extra 13921 SIMPLE t2 ALL NULL NULL NULL NULL 1199 Using where 13931 SIMPLE t4 eq_ref PRIMARY PRIMARY 1 test.t2.companynr 1 NULL 1394explain select t2.companynr,companyname from t4 left join t2 using (companynr) where t2.companynr > 0 and t4.companynr > 0; 1395id select_type table type possible_keys key key_len ref rows Extra 13961 SIMPLE t2 ALL NULL NULL NULL NULL 1199 Using where 13971 SIMPLE t4 eq_ref PRIMARY PRIMARY 1 test.t2.companynr 1 NULL 1398explain select companynr,companyname from t4 left join t2 using (companynr) where companynr > 0; 1399id select_type table type possible_keys key key_len ref rows Extra 14001 SIMPLE t4 ALL PRIMARY NULL NULL NULL 12 Using where 14011 SIMPLE t2 ALL NULL NULL NULL NULL 1199 Using where; Using join buffer (Block Nested Loop) 1402explain select companynr,companyname from t4 left join t2 using (companynr) where companynr > 0 or companynr < 0; 1403id select_type table type possible_keys key key_len ref rows Extra 14041 SIMPLE t4 ALL PRIMARY NULL NULL NULL 12 Using where 14051 SIMPLE t2 ALL NULL NULL NULL NULL 1199 Using where; Using join buffer (Block Nested Loop) 1406explain select companynr,companyname from t4 left join t2 using (companynr) where companynr > 0 and companynr > 0; 1407id select_type table type possible_keys key key_len ref rows Extra 14081 SIMPLE t4 ALL PRIMARY NULL NULL NULL 12 Using where 14091 SIMPLE t2 ALL NULL NULL NULL NULL 1199 Using where; Using join buffer (Block Nested Loop) 1410explain select t2.companynr,companyname from t4 left join t2 using (companynr) where t2.companynr > 0 or t2.companynr is null; 1411id select_type table type possible_keys key key_len ref rows Extra 14121 SIMPLE t4 ALL NULL NULL NULL NULL 12 NULL 14131 SIMPLE t2 ALL NULL NULL NULL NULL 1199 Using where; Using join buffer (Block Nested Loop) 1414explain select t2.companynr,companyname from t4 left join t2 using (companynr) where t2.companynr > 0 or t2.companynr < 0 or t4.companynr > 0; 1415id select_type table type possible_keys key key_len ref rows Extra 14161 SIMPLE t4 ALL PRIMARY NULL NULL NULL 12 NULL 14171 SIMPLE t2 ALL NULL NULL NULL NULL 1199 Using where; Using join buffer (Block Nested Loop) 1418explain select t2.companynr,companyname from t4 left join t2 using (companynr) where ifnull(t2.companynr,1)>0; 1419id select_type table type possible_keys key key_len ref rows Extra 14201 SIMPLE t4 ALL NULL NULL NULL NULL 12 NULL 14211 SIMPLE t2 ALL NULL NULL NULL NULL 1199 Using where; Using join buffer (Block Nested Loop) 1422explain select companynr,companyname from t4 left join t2 using (companynr) where companynr > 0 or companynr is null; 1423id select_type table type possible_keys key key_len ref rows Extra 14241 SIMPLE t4 ALL PRIMARY NULL NULL NULL 12 Using where 14251 SIMPLE t2 ALL NULL NULL NULL NULL 1199 Using where; Using join buffer (Block Nested Loop) 1426explain select companynr,companyname from t4 left join t2 using (companynr) where companynr > 0 or companynr < 0 or companynr > 0; 1427id select_type table type possible_keys key key_len ref rows Extra 14281 SIMPLE t4 ALL PRIMARY NULL NULL NULL 12 Using where 14291 SIMPLE t2 ALL NULL NULL NULL NULL 1199 Using where; Using join buffer (Block Nested Loop) 1430explain select companynr,companyname from t4 left join t2 using (companynr) where ifnull(companynr,1)>0; 1431id select_type table type possible_keys key key_len ref rows Extra 14321 SIMPLE t4 ALL NULL NULL NULL NULL 12 Using where 14331 SIMPLE t2 ALL NULL NULL NULL NULL 1199 Using where; Using join buffer (Block Nested Loop) 1434select distinct t2.companynr,t4.companynr from t2,t4 where t2.companynr=t4.companynr+1; 1435companynr companynr 143637 36 143741 40 1438explain select distinct t2.companynr,t4.companynr from t2,t4 where t2.companynr=t4.companynr+1; 1439id select_type table type possible_keys key key_len ref rows Extra 14401 SIMPLE t4 index NULL PRIMARY 1 NULL 12 Using index; Using temporary 14411 SIMPLE t2 ALL NULL NULL NULL NULL 1199 Using where; Using join buffer (Block Nested Loop) 1442select 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; 1443fld1 companynr fld3 period 1444038008 37 reporters 1008 1445038208 37 Selfridge 1008 1446select 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; 1447fld1 companynr fld3 period 1448038008 37 reporters 1008 1449038208 37 Selfridge 1008 1450select 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; 1451fld1 companynr fld3 period 1452038008 37 reporters 1008 1453038208 37 Selfridge 1008 1454select 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); 1455period 14569410 1457select 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))); 1458period 14599410 1460select 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; 1461fld1 1462250501 1463250502 1464250503 1465250505 1466select fld1 from t2 where fld1 in (250502,98005,98006,250503,250605,250606) and fld1 >=250502 and fld1 not in (250605,250606); 1467fld1 1468250502 1469250503 1470select fld1 from t2 where fld1 between 250502 and 250504; 1471fld1 1472250502 1473250503 1474250504 1475select fld3 from t2 where (((fld3 like "_%L%" ) or (fld3 like "%ok%")) and ( fld3 like "L%" or fld3 like "G%")) and fld3 like "L%" ; 1476fld3 1477label 1478labeled 1479labeled 1480landslide 1481laterally 1482leaflet 1483lewdly 1484Lillian 1485luckily 1486select count(*) from t1; 1487count(*) 14881 1489select companynr,count(*),sum(fld1) from t2 group by companynr; 1490companynr count(*) sum(fld1) 149100 82 10355753 149229 95 14473298 149334 70 17788966 149436 215 22786296 149537 588 83602098 149640 37 6618386 149741 52 12816335 149850 11 1595438 149953 4 793210 150058 23 2254293 150165 10 2284055 150268 12 3097288 1503select companynr,count(*) from t2 group by companynr order by companynr desc limit 5; 1504companynr count(*) 150568 12 150665 10 150758 23 150853 4 150950 11 1510select count(*),min(fld4),max(fld4),sum(fld1),avg(fld1),std(fld1),variance(fld1) from t2 where companynr = 34 and fld4<>""; 1511count(*) min(fld4) max(fld4) sum(fld1) avg(fld1) std(fld1) variance(fld1) 151270 absentee vest 17788966 254128.0857 3272.5939722090234 10709871.306938833 1513explain extended select count(*),min(fld4),max(fld4),sum(fld1),avg(fld1),std(fld1),variance(fld1) from t2 where companynr = 34 and fld4<>""; 1514id select_type table type possible_keys key key_len ref rows filtered Extra 15151 SIMPLE t2 ALL NULL NULL NULL NULL 1199 100.00 Using where 1516Warnings: 1517Note 1003 /* select#1 */ 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` <> '')) 1518select companynr,count(*),min(fld4),max(fld4),sum(fld1),avg(fld1),std(fld1),variance(fld1) from t2 group by companynr limit 3; 1519companynr count(*) min(fld4) max(fld4) sum(fld1) avg(fld1) std(fld1) variance(fld1) 152000 82 Anthony windmills 10355753 126289.6707 115550.97568479746 13352027981.708656 152129 95 abut wetness 14473298 152350.5053 8368.547956641249 70032594.90260443 152234 70 absentee vest 17788966 254128.0857 3272.5939722090234 10709871.306938833 1523select companynr,t2nr,count(price),sum(price),min(price),max(price),avg(price) from t3 where companynr = 37 group by companynr,t2nr limit 10; 1524companynr t2nr count(price) sum(price) min(price) max(price) avg(price) 152537 1 1 5987435 5987435 5987435 5987435.0000 152637 2 1 28357832 28357832 28357832 28357832.0000 152737 3 1 39654943 39654943 39654943 39654943.0000 152837 11 1 5987435 5987435 5987435 5987435.0000 152937 12 1 28357832 28357832 28357832 28357832.0000 153037 13 1 39654943 39654943 39654943 39654943.0000 153137 21 1 5987435 5987435 5987435 5987435.0000 153237 22 1 28357832 28357832 28357832 28357832.0000 153337 23 1 39654943 39654943 39654943 39654943.0000 153437 31 1 5987435 5987435 5987435 5987435.0000 1535select /*! 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; 1536companynr t2nr count(price) sum(price) min(price) max(price) avg(price) 153737 1 1 5987435 5987435 5987435 5987435.0000 153837 2 1 28357832 28357832 28357832 28357832.0000 153937 3 1 39654943 39654943 39654943 39654943.0000 154037 11 1 5987435 5987435 5987435 5987435.0000 154137 12 1 28357832 28357832 28357832 28357832.0000 154237 13 1 39654943 39654943 39654943 39654943.0000 154337 21 1 5987435 5987435 5987435 5987435.0000 154437 22 1 28357832 28357832 28357832 28357832.0000 154537 23 1 39654943 39654943 39654943 39654943.0000 154637 31 1 5987435 5987435 5987435 5987435.0000 1547select companynr,count(price),sum(price),min(price),max(price),avg(price) from t3 group by companynr ; 1548companynr count(price) sum(price) min(price) max(price) avg(price) 154937 12543 309394878010 5987435 39654943 24666736.6667 155078 8362 414611089292 726498 98439034 49582766.0000 1551101 4181 3489454238 834598 834598 834598.0000 1552154 4181 4112197254950 983543950 983543950 983543950.0000 1553311 4181 979599938 234298 234298 234298.0000 1554447 4181 9929180954 2374834 2374834 2374834.0000 1555512 4181 3288532102 786542 786542 786542.0000 1556select distinct mod(companynr,10) from t4 group by companynr; 1557mod(companynr,10) 15580 15599 15604 15616 15627 15631 15643 15658 15665 1567select distinct 1 from t4 group by companynr; 15681 15691 1570select count(distinct fld1) from t2; 1571count(distinct fld1) 15721199 1573select companynr,count(distinct fld1) from t2 group by companynr; 1574companynr count(distinct fld1) 157500 82 157629 95 157734 70 157836 215 157937 588 158040 37 158141 52 158250 11 158353 4 158458 23 158565 10 158668 12 1587select companynr,count(*) from t2 group by companynr; 1588companynr count(*) 158900 82 159029 95 159134 70 159236 215 159337 588 159440 37 159541 52 159650 11 159753 4 159858 23 159965 10 160068 12 1601select companynr,count(distinct concat(fld1,repeat(65,1000))) from t2 group by companynr; 1602companynr count(distinct concat(fld1,repeat(65,1000))) 160300 82 160429 95 160534 70 160636 215 160737 588 160840 37 160941 52 161050 11 161153 4 161258 23 161365 10 161468 12 1615select companynr,count(distinct concat(fld1,repeat(65,200))) from t2 group by companynr; 1616companynr count(distinct concat(fld1,repeat(65,200))) 161700 82 161829 95 161934 70 162036 215 162137 588 162240 37 162341 52 162450 11 162553 4 162658 23 162765 10 162868 12 1629select companynr,count(distinct floor(fld1/100)) from t2 group by companynr; 1630companynr count(distinct floor(fld1/100)) 163100 47 163229 35 163334 14 163436 69 163537 108 163640 16 163741 11 163850 9 163953 1 164058 1 164165 1 164268 1 1643select companynr,count(distinct concat(repeat(65,1000),floor(fld1/100))) from t2 group by companynr; 1644companynr count(distinct concat(repeat(65,1000),floor(fld1/100))) 164500 47 164629 35 164734 14 164836 69 164937 108 165040 16 165141 11 165250 9 165353 1 165458 1 165565 1 165668 1 1657select sum(fld1),fld3 from t2 where fld3="Romans" group by fld1 limit 10; 1658sum(fld1) fld3 165911402 Romans 1660select name,count(*) from t3 where name='cloakroom' group by name; 1661name count(*) 1662cloakroom 4181 1663select name,count(*) from t3 where name='cloakroom' and price>10 group by name; 1664name count(*) 1665cloakroom 4181 1666select count(*) from t3 where name='cloakroom' and price2=823742; 1667count(*) 16684181 1669select name,count(*) from t3 where name='cloakroom' and price2=823742 group by name; 1670name count(*) 1671cloakroom 4181 1672select name,count(*) from t3 where name >= "extramarital" and price <= 39654943 group by name; 1673name count(*) 1674extramarital 4181 1675gazer 4181 1676gems 4181 1677Iranizes 4181 1678spates 4181 1679tucked 4181 1680violinist 4181 1681select t2.fld3,count(*) from t2,t3 where t2.fld1=158402 and t3.name=t2.fld3 group by t3.name; 1682fld3 count(*) 1683spates 4181 1684select companynr|0,companyname from t4 group by 1; 1685companynr|0 companyname 16860 Unknown 168729 company 1 168834 company 2 168936 company 3 169037 company 4 169140 company 5 169241 company 6 169350 company 11 169453 company 7 169558 company 8 169665 company 9 169768 company 10 1698select t2.companynr,companyname,count(*) from t2,t4 where t2.companynr=t4.companynr group by t2.companynr order by companyname; 1699companynr companyname count(*) 170029 company 1 95 170168 company 10 12 170250 company 11 11 170334 company 2 70 170436 company 3 215 170537 company 4 588 170640 company 5 37 170741 company 6 52 170853 company 7 4 170958 company 8 23 171065 company 9 10 171100 Unknown 82 1712select t2.fld1,count(*) from t2,t3 where t2.fld1=158402 and t3.name=t2.fld3 group by t3.name; 1713fld1 count(*) 1714158402 4181 1715select sum(Period)/count(*) from t1; 1716sum(Period)/count(*) 17179410.0000 1718select companynr,count(price) as "count",sum(price) as "sum" ,abs(sum(price)/count(price)-avg(price)) as "diff",(0+count(price))*companynr as func from t3 group by companynr; 1719companynr count sum diff func 172037 12543 309394878010 0.0000 464091 172178 8362 414611089292 0.0000 652236 1722101 4181 3489454238 0.0000 422281 1723154 4181 4112197254950 0.0000 643874 1724311 4181 979599938 0.0000 1300291 1725447 4181 9929180954 0.0000 1868907 1726512 4181 3288532102 0.0000 2140672 1727select companynr,sum(price)/count(price) as avg from t3 group by companynr having avg > 70000000 order by avg; 1728companynr avg 1729154 983543950.0000 1730select companynr,count(*) from t2 group by companynr order by 2 desc; 1731companynr count(*) 173237 588 173336 215 173429 95 173500 82 173634 70 173741 52 173840 37 173958 23 174068 12 174150 11 174265 10 174353 4 1744select companynr,count(*) from t2 where companynr > 40 group by companynr order by 2 desc; 1745companynr count(*) 174641 52 174758 23 174868 12 174950 11 175065 10 175153 4 1752select t2.fld4,t2.fld1,count(price),sum(price),min(price),max(price),avg(price) from t3,t2 where t3.companynr = 37 and t2.fld1 = t3.t2nr group by fld1,t2.fld4; 1753fld4 fld1 count(price) sum(price) min(price) max(price) avg(price) 1754teethe 000001 1 5987435 5987435 5987435 5987435.0000 1755dreaded 011401 1 5987435 5987435 5987435 5987435.0000 1756scholastics 011402 1 28357832 28357832 28357832 28357832.0000 1757audiology 011403 1 39654943 39654943 39654943 39654943.0000 1758wallet 011501 1 5987435 5987435 5987435 5987435.0000 1759parters 011701 1 5987435 5987435 5987435 5987435.0000 1760eschew 011702 1 28357832 28357832 28357832 28357832.0000 1761quitter 011703 1 39654943 39654943 39654943 39654943.0000 1762neat 012001 1 5987435 5987435 5987435 5987435.0000 1763Steinberg 012003 1 39654943 39654943 39654943 39654943.0000 1764balled 012301 1 5987435 5987435 5987435 5987435.0000 1765persist 012302 1 28357832 28357832 28357832 28357832.0000 1766attainments 012303 1 39654943 39654943 39654943 39654943.0000 1767capably 012501 1 5987435 5987435 5987435 5987435.0000 1768impulsive 012602 1 28357832 28357832 28357832 28357832.0000 1769starlet 012603 1 39654943 39654943 39654943 39654943.0000 1770featherweight 012701 1 5987435 5987435 5987435 5987435.0000 1771pessimist 012702 1 28357832 28357832 28357832 28357832.0000 1772daughter 012703 1 39654943 39654943 39654943 39654943.0000 1773lawgiver 013601 1 5987435 5987435 5987435 5987435.0000 1774stated 013602 1 28357832 28357832 28357832 28357832.0000 1775readable 013603 1 39654943 39654943 39654943 39654943.0000 1776testicle 013801 1 5987435 5987435 5987435 5987435.0000 1777Parsifal 013802 1 28357832 28357832 28357832 28357832.0000 1778leavings 013803 1 39654943 39654943 39654943 39654943.0000 1779squeaking 013901 1 5987435 5987435 5987435 5987435.0000 1780contrasted 016001 1 5987435 5987435 5987435 5987435.0000 1781leftover 016201 1 5987435 5987435 5987435 5987435.0000 1782whiteners 016202 1 28357832 28357832 28357832 28357832.0000 1783erases 016301 1 5987435 5987435 5987435 5987435.0000 1784Punjab 016302 1 28357832 28357832 28357832 28357832.0000 1785Merritt 016303 1 39654943 39654943 39654943 39654943.0000 1786sweetish 018001 1 5987435 5987435 5987435 5987435.0000 1787dogging 018002 1 28357832 28357832 28357832 28357832.0000 1788scornfully 018003 1 39654943 39654943 39654943 39654943.0000 1789fetters 018012 1 28357832 28357832 28357832 28357832.0000 1790bivalves 018013 1 39654943 39654943 39654943 39654943.0000 1791skulking 018021 1 5987435 5987435 5987435 5987435.0000 1792flint 018022 1 28357832 28357832 28357832 28357832.0000 1793flopping 018023 1 39654943 39654943 39654943 39654943.0000 1794Judas 018032 1 28357832 28357832 28357832 28357832.0000 1795vacuuming 018033 1 39654943 39654943 39654943 39654943.0000 1796medical 018041 1 5987435 5987435 5987435 5987435.0000 1797bloodbath 018042 1 28357832 28357832 28357832 28357832.0000 1798subschema 018043 1 39654943 39654943 39654943 39654943.0000 1799interdependent 018051 1 5987435 5987435 5987435 5987435.0000 1800Graves 018052 1 28357832 28357832 28357832 28357832.0000 1801neonatal 018053 1 39654943 39654943 39654943 39654943.0000 1802sorters 018061 1 5987435 5987435 5987435 5987435.0000 1803epistle 018062 1 28357832 28357832 28357832 28357832.0000 1804Conley 018101 1 5987435 5987435 5987435 5987435.0000 1805lectured 018102 1 28357832 28357832 28357832 28357832.0000 1806Abraham 018103 1 39654943 39654943 39654943 39654943.0000 1807cage 018201 1 5987435 5987435 5987435 5987435.0000 1808hushes 018202 1 28357832 28357832 28357832 28357832.0000 1809Simla 018402 1 28357832 28357832 28357832 28357832.0000 1810reporters 018403 1 39654943 39654943 39654943 39654943.0000 1811coexist 018601 1 5987435 5987435 5987435 5987435.0000 1812Beebe 018602 1 28357832 28357832 28357832 28357832.0000 1813Taoism 018603 1 39654943 39654943 39654943 39654943.0000 1814Connally 018801 1 5987435 5987435 5987435 5987435.0000 1815fetched 018802 1 28357832 28357832 28357832 28357832.0000 1816checkpoints 018803 1 39654943 39654943 39654943 39654943.0000 1817gritty 018811 1 5987435 5987435 5987435 5987435.0000 1818firearm 018812 1 28357832 28357832 28357832 28357832.0000 1819minima 019101 1 5987435 5987435 5987435 5987435.0000 1820Selfridge 019102 1 28357832 28357832 28357832 28357832.0000 1821disable 019103 1 39654943 39654943 39654943 39654943.0000 1822witchcraft 019201 1 5987435 5987435 5987435 5987435.0000 1823betroth 030501 1 5987435 5987435 5987435 5987435.0000 1824Manhattanize 030502 1 28357832 28357832 28357832 28357832.0000 1825imprint 030503 1 39654943 39654943 39654943 39654943.0000 1826swelling 031901 1 5987435 5987435 5987435 5987435.0000 1827interrelationships 036001 1 5987435 5987435 5987435 5987435.0000 1828riser 036002 1 28357832 28357832 28357832 28357832.0000 1829bee 038001 1 5987435 5987435 5987435 5987435.0000 1830kanji 038002 1 28357832 28357832 28357832 28357832.0000 1831dental 038003 1 39654943 39654943 39654943 39654943.0000 1832railway 038011 1 5987435 5987435 5987435 5987435.0000 1833validate 038012 1 28357832 28357832 28357832 28357832.0000 1834normalizes 038013 1 39654943 39654943 39654943 39654943.0000 1835Kline 038101 1 5987435 5987435 5987435 5987435.0000 1836Anatole 038102 1 28357832 28357832 28357832 28357832.0000 1837partridges 038103 1 39654943 39654943 39654943 39654943.0000 1838recruited 038201 1 5987435 5987435 5987435 5987435.0000 1839dimensions 038202 1 28357832 28357832 28357832 28357832.0000 1840Chicana 038203 1 39654943 39654943 39654943 39654943.0000 1841select t3.companynr,fld3,sum(price) from t3,t2 where t2.fld1 = t3.t2nr and t3.companynr = 512 group by companynr,fld3; 1842companynr fld3 sum(price) 1843512 boat 786542 1844512 capably 786542 1845512 cupboard 786542 1846512 decliner 786542 1847512 descendants 786542 1848512 dopers 786542 1849512 erases 786542 1850512 Micronesia 786542 1851512 Miles 786542 1852512 skies 786542 1853select t2.companynr,count(*),min(fld3),max(fld3),sum(price),avg(price) from t2,t3 where t3.companynr >= 30 and t3.companynr <= 58 and t3.t2nr = t2.fld1 and 1+1=2 group by t2.companynr; 1854companynr count(*) min(fld3) max(fld3) sum(price) avg(price) 185500 1 Omaha Omaha 5987435 5987435.0000 185636 1 dubbed dubbed 28357832 28357832.0000 185737 83 Abraham Wotan 1908978016 22999735.1325 185850 2 scribbled tapestry 68012775 34006387.5000 1859select t3.companynr+0,t3.t2nr,fld3,sum(price) from t3,t2 where t2.fld1 = t3.t2nr and t3.companynr = 37 group by 1,t3.t2nr,fld3,fld3,fld3,fld3,fld3 order by fld1; 1860t3.companynr+0 t2nr fld3 sum(price) 186137 1 Omaha 5987435 186237 11401 breaking 5987435 186337 11402 Romans 28357832 186437 11403 intercepted 39654943 186537 11501 bewilderingly 5987435 186637 11701 astound 5987435 186737 11702 admonishing 28357832 186837 11703 sumac 39654943 186937 12001 flanking 5987435 187037 12003 combed 39654943 187137 12301 Eulerian 5987435 187237 12302 dubbed 28357832 187337 12303 Kane 39654943 187437 12501 annihilates 5987435 187537 12602 Wotan 28357832 187637 12603 snatching 39654943 187737 12701 grazing 5987435 187837 12702 Baird 28357832 187937 12703 celery 39654943 188037 13601 handgun 5987435 188137 13602 foldout 28357832 188237 13603 mystic 39654943 188337 13801 intelligibility 5987435 188437 13802 Augustine 28357832 188537 13803 teethe 39654943 188637 13901 scholastics 5987435 188737 16001 audiology 5987435 188837 16201 wallet 5987435 188937 16202 parters 28357832 189037 16301 eschew 5987435 189137 16302 quitter 28357832 189237 16303 neat 39654943 189337 18001 jarring 5987435 189437 18002 tinily 28357832 189537 18003 balled 39654943 189637 18012 impulsive 28357832 189737 18013 starlet 39654943 189837 18021 lawgiver 5987435 189937 18022 stated 28357832 190037 18023 readable 39654943 190137 18032 testicle 28357832 190237 18033 Parsifal 39654943 190337 18041 Punjab 5987435 190437 18042 Merritt 28357832 190537 18043 Quixotism 39654943 190637 18051 sureties 5987435 190737 18052 puddings 28357832 190837 18053 tapestry 39654943 190937 18061 trimmings 5987435 191037 18062 humility 28357832 191137 18101 tragedies 5987435 191237 18102 skulking 28357832 191337 18103 flint 39654943 191437 18201 relaxing 5987435 191537 18202 offload 28357832 191637 18402 suites 28357832 191737 18403 lists 39654943 191837 18601 vacuuming 5987435 191937 18602 dentally 28357832 192037 18603 humanness 39654943 192137 18801 inch 5987435 192237 18802 Weissmuller 28357832 192337 18803 irresponsibly 39654943 192437 18811 repetitions 5987435 192537 18812 Antares 28357832 192637 19101 ventilate 5987435 192737 19102 pityingly 28357832 192837 19103 interdependent 39654943 192937 19201 Graves 5987435 193037 30501 neonatal 5987435 193137 30502 scribbled 28357832 193237 30503 chafe 39654943 193337 31901 realtor 5987435 193437 36001 elite 5987435 193537 36002 funereal 28357832 193637 38001 Conley 5987435 193737 38002 lectured 28357832 193837 38003 Abraham 39654943 193937 38011 groupings 5987435 194037 38012 dissociate 28357832 194137 38013 coexist 39654943 194237 38101 rusting 5987435 194337 38102 galling 28357832 194437 38103 obliterates 39654943 194537 38201 resumes 5987435 194637 38202 analyzable 28357832 194737 38203 terminator 39654943 1948select sum(price) from t3,t2 where t2.fld1 = t3.t2nr and t3.companynr = 512 and t3.t2nr = 38008 and t2.fld1 = 38008 or t2.fld1= t3.t2nr and t3.t2nr = 38008 and t2.fld1 = 38008; 1949sum(price) 1950234298 1951select t2.fld1,sum(price) from t3,t2 where t2.fld1 = t3.t2nr and t3.companynr = 512 and t3.t2nr = 38008 and t2.fld1 = 38008 or t2.fld1 = t3.t2nr and t3.t2nr = 38008 and t2.fld1 = 38008 or t3.t2nr = t2.fld1 and t2.fld1 = 38008 group by t2.fld1; 1952fld1 sum(price) 1953038008 234298 1954explain select fld3 from t2 where 1>2 or 2>3; 1955id select_type table type possible_keys key key_len ref rows Extra 19561 SIMPLE NULL NULL NULL NULL NULL NULL NULL Impossible WHERE 1957explain select fld3 from t2 where fld1=fld1; 1958id select_type table type possible_keys key key_len ref rows Extra 19591 SIMPLE t2 ALL NULL NULL NULL NULL 1199 NULL 1960select companynr,fld1 from t2 HAVING fld1=250501 or fld1=250502; 1961companynr fld1 196234 250501 196334 250502 1964select companynr,fld1 from t2 WHERE fld1>=250501 HAVING fld1<=250502; 1965companynr fld1 196634 250501 196734 250502 1968select companynr,count(*) as count,sum(fld1) as sum from t2 group by companynr having count > 40 and sum/count >= 120000; 1969companynr count sum 197000 82 10355753 197129 95 14473298 197234 70 17788966 197337 588 83602098 197441 52 12816335 1975select companynr from t2 group by companynr having count(*) > 40 and sum(fld1)/count(*) >= 120000 ; 1976companynr 197700 197829 197934 198037 198141 1982select t2.companynr,companyname,count(*) from t2,t4 where t2.companynr=t4.companynr group by companyname having t2.companynr >= 40; 1983companynr companyname count(*) 198468 company 10 12 198550 company 11 11 198640 company 5 37 198741 company 6 52 198853 company 7 4 198958 company 8 23 199065 company 9 10 1991select count(*) from t2; 1992count(*) 19931199 1994select count(*) from t2 where fld1 < 098024; 1995count(*) 1996387 1997select min(fld1) from t2 where fld1>= 098024; 1998min(fld1) 199998024 2000select max(fld1) from t2 where fld1>= 098024; 2001max(fld1) 20021232609 2003select count(*) from t3 where price2=76234234; 2004count(*) 20054181 2006select count(*) from t3 where companynr=512 and price2=76234234; 2007count(*) 20084181 2009explain select min(fld1),max(fld1),count(*) from t2; 2010id select_type table type possible_keys key key_len ref rows Extra 20111 SIMPLE NULL NULL NULL NULL NULL NULL NULL Select tables optimized away 2012select min(fld1),max(fld1),count(*) from t2; 2013min(fld1) max(fld1) count(*) 20140 1232609 1199 2015select min(t2nr),max(t2nr) from t3 where t2nr=2115 and price2=823742; 2016min(t2nr) max(t2nr) 20172115 2115 2018select count(*),min(t2nr),max(t2nr) from t3 where name='spates' and companynr=78; 2019count(*) min(t2nr) max(t2nr) 20204181 4 41804 2021select t2nr,count(*) from t3 where name='gems' group by t2nr limit 20; 2022t2nr count(*) 20239 1 202419 1 202529 1 202639 1 202749 1 202859 1 202969 1 203079 1 203189 1 203299 1 2033109 1 2034119 1 2035129 1 2036139 1 2037149 1 2038159 1 2039169 1 2040179 1 2041189 1 2042199 1 2043select max(t2nr) from t3 where price=983543950; 2044max(t2nr) 204541807 2046select t1.period from t3 = t1 limit 1; 2047period 20481001 2049select t1.period from t1 as t1 limit 1; 2050period 20519410 2052select t1.period as "Nuvarande period" from t1 as t1 limit 1; 2053Nuvarande period 20549410 2055select period as ok_period from t1 limit 1; 2056ok_period 20579410 2058select period as ok_period from t1 group by ok_period limit 1; 2059ok_period 20609410 2061select 1+1 as summa from t1 group by summa limit 1; 2062summa 20632 2064select period as "Nuvarande period" from t1 group by "Nuvarande period" limit 1; 2065Nuvarande period 20669410 2067show tables; 2068Tables_in_test 2069t1 2070t2 2071t3 2072t4 2073show tables from test like "s%"; 2074Tables_in_test (s%) 2075show tables from test like "t?"; 2076Tables_in_test (t?) 2077show full columns from t2; 2078Field Type Collation Null Key Default Extra Privileges Comment 2079auto int(11) NULL NO PRI NULL auto_increment # 2080fld1 int(6) unsigned zerofill NULL NO UNI 000000 # 2081companynr tinyint(2) unsigned zerofill NULL NO 00 # 2082fld3 char(30) latin1_swedish_ci NO MUL # 2083fld4 char(35) latin1_swedish_ci NO # 2084fld5 char(35) latin1_swedish_ci NO # 2085fld6 char(4) latin1_swedish_ci NO # 2086show full columns from t2 from test like 'f%'; 2087Field Type Collation Null Key Default Extra Privileges Comment 2088fld1 int(6) unsigned zerofill NULL NO UNI 000000 # 2089fld3 char(30) latin1_swedish_ci NO MUL # 2090fld4 char(35) latin1_swedish_ci NO # 2091fld5 char(35) latin1_swedish_ci NO # 2092fld6 char(4) latin1_swedish_ci NO # 2093show full columns from t2 from test like 's%'; 2094Field Type Collation Null Key Default Extra Privileges Comment 2095show keys from t2; 2096Table Non_unique Key_name Seq_in_index Column_name Collation Cardinality Sub_part Packed Null Index_type Comment Index_comment 2097t2 0 PRIMARY 1 auto A 1199 NULL NULL BTREE 2098t2 0 fld1 1 fld1 A 1199 NULL NULL BTREE 2099t2 1 fld3 1 fld3 A NULL NULL NULL BTREE 2100drop table t4, t3, t2, t1; 2101CREATE TABLE t1 ( 2102cont_nr int(11) NOT NULL auto_increment, 2103ver_nr int(11) NOT NULL default '0', 2104aufnr int(11) NOT NULL default '0', 2105username varchar(50) NOT NULL default '', 2106hdl_nr int(11) NOT NULL default '0', 2107eintrag date NOT NULL default '0000-00-00', 2108st_klasse varchar(40) NOT NULL default '', 2109st_wert varchar(40) NOT NULL default '', 2110st_zusatz varchar(40) NOT NULL default '', 2111st_bemerkung varchar(255) NOT NULL default '', 2112kunden_art varchar(40) NOT NULL default '', 2113mcbs_knr int(11) default NULL, 2114mcbs_aufnr int(11) NOT NULL default '0', 2115schufa_status char(1) default '?', 2116bemerkung text, 2117wirknetz text, 2118wf_igz int(11) NOT NULL default '0', 2119tarifcode varchar(80) default NULL, 2120recycle char(1) default NULL, 2121sim varchar(30) default NULL, 2122mcbs_tpl varchar(30) default NULL, 2123emp_nr int(11) NOT NULL default '0', 2124laufzeit int(11) default NULL, 2125hdl_name varchar(30) default NULL, 2126prov_hdl_nr int(11) NOT NULL default '0', 2127auto_wirknetz varchar(50) default NULL, 2128auto_billing varchar(50) default NULL, 2129touch timestamp NOT NULL, 2130kategorie varchar(50) default NULL, 2131kundentyp varchar(20) NOT NULL default '', 2132sammel_rech_msisdn varchar(30) NOT NULL default '', 2133p_nr varchar(9) NOT NULL default '', 2134suffix char(3) NOT NULL default '', 2135PRIMARY KEY (cont_nr), 2136KEY idx_aufnr(aufnr), 2137KEY idx_hdl_nr(hdl_nr), 2138KEY idx_st_klasse(st_klasse), 2139KEY ver_nr(ver_nr), 2140KEY eintrag_idx(eintrag), 2141KEY emp_nr_idx(emp_nr), 2142KEY wf_igz(wf_igz), 2143KEY touch(touch), 2144KEY hdl_tag(eintrag,hdl_nr), 2145KEY prov_hdl_nr(prov_hdl_nr), 2146KEY mcbs_aufnr(mcbs_aufnr), 2147KEY kundentyp(kundentyp), 2148KEY p_nr(p_nr,suffix) 2149) ENGINE=MyISAM; 2150INSERT INTO t1 VALUES (3359356,405,3359356,'Mustermann Musterfrau',52500,'2000-05-20','workflow','Auftrag erledigt','Originalvertrag eingegangen und geprüft','','privat',1485525,2122316,'+','','N',1909160,'MobilComSuper92000D2',NULL,NULL,'MS9ND2',3,24,'MobilCom Shop Koeln',52500,NULL,'auto',20010202105916,'Mobilfunk','PP','','',''); 2151INSERT INTO t1 VALUES (3359357,468,3359357,'Mustermann Musterfrau',7001,'2000-05-20','workflow','Auftrag erledigt','Originalvertrag eingegangen und geprüft','','privat',1503580,2139699,'+','','P',1909171,'MobilComSuper9D1T10SFreisprech(Akquise)',NULL,NULL,'MS9NS1',327,24,'MobilCom Intern',7003,NULL,'auto',20010202105916,'Mobilfunk','PP','','',''); 2152INSERT INTO t1 VALUES (3359358,407,3359358,'Mustermann Musterfrau',7001,'2000-05-20','workflow','Auftrag erledigt','Originalvertrag eingegangen und geprüft','','privat',1501358,2137473,'N','','N',1909159,'MobilComSuper92000D2',NULL,NULL,'MS9ND2',325,24,'MobilCom Intern',7003,NULL,'auto',20010202105916,'Mobilfunk','PP','','',''); 2153INSERT INTO t1 VALUES (3359359,468,3359359,'Mustermann Musterfrau',7001,'2000-05-20','workflow','Auftrag erledigt','Originalvertrag eingegangen und geprüft','','privat',1507831,2143894,'+','','P',1909162,'MobilComSuper9D1T10SFreisprech(Akquise)',NULL,NULL,'MS9NS1',327,24,'MobilCom Intern',7003,NULL,'auto',20010202105916,'Mobilfunk','PP','','',''); 2154INSERT INTO t1 VALUES (3359360,0,0,'Mustermann Musterfrau',29674907,'2000-05-20','workflow','Auftrag erledigt','Originalvertrag eingegangen und geprüft','','privat',1900169997,2414578,'+',NULL,'N',1909148,'',NULL,NULL,'RV99066_2',20,NULL,'POS',29674907,NULL,NULL,20010202105916,'Mobilfunk','','','97317481','007'); 2155INSERT INTO t1 VALUES (3359361,406,3359361,'Mustermann Musterfrau',7001,'2000-05-20','workflow','Auftrag storniert','','(7001-84):Storno, Kd. möchte nicht mehr','privat',NULL,0,'+','','P',1909150,'MobilComSuper92000D1(Akquise)',NULL,NULL,'MS9ND1',325,24,'MobilCom Intern',7003,NULL,'auto',20010202105916,'Mobilfunk','PP','','',''); 2156INSERT INTO t1 VALUES (3359362,406,3359362,'Mustermann Musterfrau',7001,'2000-05-20','workflow','Auftrag erledigt','Originalvertrag eingegangen und geprüft','','privat',1509984,2145874,'+','','P',1909154,'MobilComSuper92000D1(Akquise)',NULL,NULL,'MS9ND1',327,24,'MobilCom Intern',7003,NULL,'auto',20010202105916,'Mobilfunk','PP','','',''); 2157SELECT ELT(FIELD(kundentyp,'PP','PPA','PG','PGA','FK','FKA','FP','FPA','K','KA','V','VA',''), 'Privat (Private Nutzung)','Privat (Private Nutzung) Sitz im Ausland','Privat (geschaeftliche Nutzung)','Privat (geschaeftliche Nutzung) Sitz im Ausland','Firma (Kapitalgesellschaft)','Firma (Kapitalgesellschaft) Sitz im Ausland','Firma (Personengesellschaft)','Firma (Personengesellschaft) Sitz im Ausland','oeff. rechtl. Koerperschaft','oeff. rechtl. Koerperschaft Sitz im Ausland','Eingetragener Verein','Eingetragener Verein Sitz im Ausland','Typ unbekannt') AS Kundentyp ,kategorie FROM t1 WHERE hdl_nr < 2000000 AND kategorie IN ('Prepaid','Mobilfunk') AND st_klasse = 'Workflow' GROUP BY kundentyp ORDER BY kategorie; 2158Kundentyp kategorie 2159Privat (Private Nutzung) Mobilfunk 2160Warnings: 2161Warning 1052 Column 'kundentyp' in group statement is ambiguous 2162drop table t1; 2163SHOW STATUS LIKE 'Ssl_cipher'; 2164Variable_name Value 2165Ssl_cipher SSL_CIPHER 2166# 2167# Bug#54790: Use of non-blocking mode for sockets limits performance 2168# 2169# Open ssl_con and set a timeout. 2170SET @@SESSION.wait_timeout = 2; 2171# Wait for ssl_con to be disconnected. 2172# Check that ssl_con has been disconnected. 2173# CR_SERVER_LOST, CR_SERVER_GONE_ERROR 2174SELECT 1; 2175Got one of the listed errors 2176