开通博客赚积分
发布资源赚积分
分类

源码开发语言/平台
当前位置：首页 > 源码/资料 > 数据库系统 > MySQL数据库 > 查看源码
select.result
资源名称：mysql-3.23.35.tar.gz　[点击查看]
上传用户：tsgydb
上传日期：2007-04-14
资源大小：10674k
文件大小：31k
源码类别：

MySQL数据库

开发平台：

Visual C++

select.result：源码内容
  1. period
  2. 9410
  3. Period Varor_period
  4. 9410 9412
  5. Period Varor_period
  6. 9410 9412
  7. fld3
  8. imaginable
  9. fld3
  10. cultivation
  11. fld3 companynr
  12. concoct 58
  13. druggists 58
  14. engrossing 58
  15. Eurydice 58
  16. exclaimers 58
  17. ferociousness 58
  18. hopelessness 58
  19. Huey 58
  20. imaginable 58
  21. judges 58
  22. merging 58
  23. ostrich 58
  24. peering 58
  25. Phelps 58
  26. presumes 58
  27. Ruth 58
  28. sentences 58
  29. Shylock 58
  30. straggled 58
  31. synergy 58
  32. thanking 58
  33. tying 58
  34. unlocks 58
  35. fld3 companynr
  36. concoct 58
  37. druggists 58
  38. engrossing 58
  39. Eurydice 58
  40. exclaimers 58
  41. ferociousness 58
  42. hopelessness 58
  43. Huey 58
  44. imaginable 58
  45. judges 58
  46. merging 58
  47. ostrich 58
  48. peering 58
  49. Phelps 58
  50. presumes 58
  51. Ruth 58
  52. sentences 58
  53. Shylock 58
  54. straggled 58
  55. synergy 58
  56. thanking 58
  57. tying 58
  58. unlocks 58
  59. fld3
  60. youthfulness
  61. yelped
  62. Wotan
  63. workers
  64. Witt
  65. witchcraft
  66. Winsett
  67. Willy
  68. willed
  69. wildcats
  70. fld3
  71. youthfulness
  72. yelped
  73. Wotan
  74. workers
  75. Witt
  76. fld3
  77. witchcraft
  78. Winsett
  79. Willy
  80. willed
  81. wildcats
  82. fld3
  83. honeysuckle
  84. fld3
  85. honeysuckle
  86. fld3
  87. honeysuckle
  88. fld3
  89. honeysuckle
  90. fld3
  91. honeysuckle
  92. fld3
  93. fld3
  94. table type possible_keys key key_len ref rows Extra
  95. t2 ref fld3 fld3 30 const 1 where used; Using index
  96. table type possible_keys key key_len ref rows Extra
  97. t2 index fld3 fld3 30 NULL 1199 where used; Using index
  98. table type possible_keys key key_len ref rows Extra
  99. t2 index fld3 fld3 30 NULL 1199 where used; Using index
  100. table type possible_keys key key_len ref rows Extra
  101. t2 ref fld3 fld3 30 const 1 where used; Using index
  102. table type possible_keys key key_len ref rows Extra
  103. t2 ref fld3 fld3 30 const 1 where used; Using index
  104. fld3
  105. honeysuckle
  106. honoring
  107. table type possible_keys key key_len ref rows Extra
  108. t2 range fld3 fld3 30 NULL 2 where used; Using index
  109. fld1 fld3
  110. 148504 Colombo
  111. 068305 Colombo
  112. 000000 nondecreasing
  113. fld1 fld3
  114. 232605 appendixes
  115. 1232605 appendixes
  116. 1232606 appendixes
  117. 1232607 appendixes
  118. 1232608 appendixes
  119. 1232609 appendixes
  120. fld1
  121. 250501
  122. 250502
  123. table type possible_keys key key_len ref rows Extra
  124. t2 range fld1 fld1 4 NULL 2 where used; Using index
  125. fld1
  126. 250501
  127. 250502
  128. 250505
  129. 250601
  130. table type possible_keys key key_len ref rows Extra
  131. t2 range fld1 fld1 4 NULL 4 where used; Using index
  132. fld1 fld3
  133. 218401 faithful
  134. 018007 fanatic
  135. 228311 fated
  136. 018017 featherweight
  137. 218022 feed
  138. 088303 feminine
  139. 058004 Fenton
  140. 038017 fetched
  141. 018054 fetters
  142. 208101 fiftieth
  143. 238007 filial
  144. 013606 fingerings
  145. 218008 finishers
  146. 038205 firearm
  147. 188505 fitting
  148. 202301 Fitzpatrick
  149. 238008 fixedly
  150. 012001 flanking
  151. 018103 flint
  152. 018104 flopping
  153. 188007 flurried
  154. 013602 foldout
  155. 226205 foothill
  156. 232102 forgivably
  157. 228306 forthcoming
  158. 186002 freakish
  159. 208113 freest
  160. 231315 freezes
  161. 036002 funereal
  162. 226209 furnishings
  163. 198006 furthermore
  164. fld3
  165. fld3
  166. Chantilly
  167. fld1 fld3
  168. 250501 poisoning
  169. 250502 Iraqis
  170. 250503 heaving
  171. 250504 population
  172. 250505 bomb
  173. fld1 fld3
  174. 250501 poisoning
  175. 250502 Iraqis
  176. 250503 heaving
  177. 250504 population
  178. 250505 bomb
  179. companynr
  180. 00
  181. 37
  182. 36
  183. 50
  184. 58
  185. 29
  186. 40
  187. 53
  188. 65
  189. 41
  190. 34
  191. 68
  192. companynr
  193. 00
  194. 29
  195. 34
  196. 36
  197. 37
  198. 40
  199. 41
  200. 50
  201. 53
  202. 58
  203. 65
  204. 68
  205. companynr
  206. 68
  207. 65
  208. 58
  209. 53
  210. 50
  211. 41
  212. 40
  213. 37
  214. 36
  215. 34
  216. 29
  217. 00
  218. fld3 period
  219. obliterates 9410
  220. offload 9410
  221. opaquely 9410
  222. organizer 9410
  223. overestimating 9410
  224. overlay 9410
  225. fld3
  226. absentee
  227. accessed
  228. ahead
  229. alphabetic
  230. Asiaticizations
  231. attitude
  232. aye
  233. bankruptcies
  234. belays
  235. Blythe
  236. bomb
  237. boulevard
  238. bulldozes
  239. cannot
  240. caressing
  241. charcoal
  242. checksumming
  243. chess
  244. clubroom
  245. colorful
  246. cosy
  247. creator
  248. crying
  249. Darius
  250. diffusing
  251. duality
  252. Eiffel
  253. Epiphany
  254. Ernestine
  255. explorers
  256. exterminated
  257. famine
  258. forked
  259. Gershwins
  260. heaving
  261. Hodges
  262. Iraqis
  263. Italianization
  264. Lagos
  265. landslide
  266. libretto
  267. Majorca
  268. mastering
  269. narrowed
  270. occurred
  271. offerers
  272. Palestine
  273. Peruvianizes
  274. pharmaceutic
  275. poisoning
  276. population
  277. Pygmalion
  278. rats
  279. realest
  280. recording
  281. regimented
  282. retransmitting
  283. reviver
  284. rouses
  285. scars
  286. sicker
  287. sleepwalk
  288. stopped
  289. sugars
  290. translatable
  291. uncles
  292. unexpected
  293. uprisings
  294. versatility
  295. vest
  296. fld3
  297. abates
  298. abiding
  299. Abraham
  300. abrogating
  301. absentee
  302. abut
  303. accessed
  304. accruing
  305. accumulating
  306. accuracies
  307. fld3
  308. abates
  309. abiding
  310. Abraham
  311. abrogating
  312. absentee
  313. abut
  314. accessed
  315. accruing
  316. accumulating
  317. accuracies
  318. substring(fld3,1,3)
  319. aba
  320. abi
  321. Abr
  322. abs
  323. abu
  324. acc
  325. acq
  326. acu
  327. Ade
  328. adj
  329. Adl
  330. adm
  331. Ado
  332. ads
  333. adv
  334. aer
  335. aff
  336. afi
  337. afl
  338. afo
  339. agi
  340. ahe
  341. aim
  342. air
  343. Ald
  344. alg
  345. ali
  346. all
  347. alp
  348. alr
  349. ama
  350. ame
  351. amm
  352. ana
  353. and
  354. ane
  355. Ang
  356. ani
  357. Ann
  358. Ant
  359. api
  360. app
  361. aqu
  362. Ara
  363. arc
  364. Arm
  365. arr
  366. Art
  367. Asi
  368. ask
  369. asp
  370. ass
  371. ast
  372. att
  373. aud
  374. Aug
  375. aut
  376. ave
  377. avo
  378. awe
  379. aye
  380. Azt
  381. a
  382. aba
  383. abi
  384. Abr
  385. abs
  386. abu
  387. acc
  388. acq
  389. acu
  390. Ade
  391. adj
  392. substring(fld3,1,3)
  393. aba
  394. abi
  395. Abr
  396. abs
  397. abu
  398. acc
  399. acq
  400. acu
  401. Ade
  402. adj
  403. a
  404. aba
  405. abi
  406. Abr
  407. abs
  408. abu
  409. acc
  410. acq
  411. acu
  412. Ade
  413. adj
  414. namn
  415. Abraham Abraham
  416. abrogating abrogating
  417. admonishing admonishing
  418. Adolph Adolph
  419. afield afield
  420. aging aging
  421. ammonium ammonium
  422. analyzable analyzable
  423. animals animals
  424. animized animized
  425. concat(fld3," ",fld3)
  426. Abraham Abraham
  427. abrogating abrogating
  428. admonishing admonishing
  429. Adolph Adolph
  430. afield afield
  431. aging aging
  432. ammonium ammonium
  433. analyzable analyzable
  434. animals animals
  435. animized animized
  436. fld5
  437. neat
  438. Steinberg
  439. jarring
  440. tinily
  441. balled
  442. persist
  443. attainments
  444. fanatic
  445. measures
  446. rightfulness
  447. fld3 count(*)
  448. affixed 1
  449. and 1
  450. annoyers 1
  451. Anthony 1
  452. assayed 1
  453. assurers 1
  454. attendants 1
  455. bedlam 1
  456. bedpost 1
  457. boasted 1
  458. fld3 count(*)
  459. affixed 1
  460. and 1
  461. annoyers 1
  462. Anthony 1
  463. assayed 1
  464. assurers 1
  465. attendants 1
  466. bedlam 1
  467. bedpost 1
  468. boasted 1
  469. fld3 repeat("a",length(fld3)) count(*)
  470. circus aaaaaa 1
  471. cited aaaaa 1
  472. Colombo aaaaaaa 1
  473. congresswoman aaaaaaaaaaaaa 1
  474. contrition aaaaaaaaaa 1
  475. corny aaaaa 1
  476. cultivation aaaaaaaaaaa 1
  477. definiteness aaaaaaaaaaaa 1
  478. demultiplex aaaaaaaaaaa 1
  479. disappointing aaaaaaaaaaaaa 1
  480. companynr rtrim(space(512+companynr))
  481. 37
  482. 78
  483. 101
  484. 154
  485. 311
  486. 447
  487. 512
  488. fld3
  489. table type possible_keys key key_len ref rows Extra
  490. t2 ALL fld1 NULL NULL NULL 1199 where used; Using temporary; Using filesort
  491. t3 eq_ref PRIMARY PRIMARY 4 t2.fld1 1 where used; Using index
  492. period
  493. 9410
  494. period
  495. fld3 period
  496. breaking 9410
  497. fld3 period
  498. breaking 1001
  499. table type possible_keys key key_len ref rows Extra
  500. t2 const fld1 fld1 4 const 1
  501. t3 const PRIMARY,period PRIMARY 4 const 1
  502. fld3 period
  503. breaking 9410
  504. Romans 9410
  505. intercepted 9410
  506. bewilderingly 9410
  507. astound 9410
  508. admonishing 9410
  509. sumac 9410
  510. flanking 9410
  511. combed 9410
  512. subjective 9410
  513. scatterbrain 9410
  514. Eulerian 9410
  515. Kane 9410
  516. overlay 9410
  517. perturb 9410
  518. goblins 9410
  519. annihilates 9410
  520. Wotan 9410
  521. snatching 9410
  522. concludes 9410
  523. laterally 9410
  524. yelped 9410
  525. grazing 9410
  526. Baird 9410
  527. celery 9410
  528. misunderstander 9410
  529. handgun 9410
  530. foldout 9410
  531. mystic 9410
  532. succumbed 9410
  533. Nabisco 9410
  534. fingerings 9410
  535. aging 9410
  536. afield 9410
  537. ammonium 9410
  538. boat 9410
  539. intelligibility 9410
  540. Augustine 9410
  541. teethe 9410
  542. dreaded 9410
  543. scholastics 9410
  544. audiology 9410
  545. wallet 9410
  546. parters 9410
  547. eschew 9410
  548. quitter 9410
  549. neat 9410
  550. Steinberg 9410
  551. jarring 9410
  552. tinily 9410
  553. balled 9410
  554. persist 9410
  555. attainments 9410
  556. fanatic 9410
  557. measures 9410
  558. rightfulness 9410
  559. capably 9410
  560. impulsive 9410
  561. starlet 9410
  562. terminators 9410
  563. untying 9410
  564. announces 9410
  565. featherweight 9410
  566. pessimist 9410
  567. daughter 9410
  568. decliner 9410
  569. lawgiver 9410
  570. stated 9410
  571. readable 9410
  572. attrition 9410
  573. cascade 9410
  574. motors 9410
  575. interrogate 9410
  576. pests 9410
  577. stairway 9410
  578. dopers 9410
  579. testicle 9410
  580. Parsifal 9410
  581. leavings 9410
  582. postulation 9410
  583. squeaking 9410
  584. contrasted 9410
  585. leftover 9410
  586. whiteners 9410
  587. erases 9410
  588. Punjab 9410
  589. Merritt 9410
  590. Quixotism 9410
  591. sweetish 9410
  592. dogging 9410
  593. scornfully 9410
  594. bellow 9410
  595. bills 9410
  596. cupboard 9410
  597. sureties 9410
  598. puddings 9410
  599. fetters 9410
  600. bivalves 9410
  601. incurring 9410
  602. Adolph 9410
  603. pithed 9410
  604. Miles 9410
  605. trimmings 9410
  606. tragedies 9410
  607. skulking 9410
  608. flint 9410
  609. flopping 9410
  610. relaxing 9410
  611. offload 9410
  612. suites 9410
  613. lists 9410
  614. animized 9410
  615. multilayer 9410
  616. standardizes 9410
  617. Judas 9410
  618. vacuuming 9410
  619. dentally 9410
  620. humanness 9410
  621. inch 9410
  622. Weissmuller 9410
  623. irresponsibly 9410
  624. luckily 9410
  625. culled 9410
  626. medical 9410
  627. bloodbath 9410
  628. subschema 9410
  629. animals 9410
  630. Micronesia 9410
  631. repetitions 9410
  632. Antares 9410
  633. ventilate 9410
  634. pityingly 9410
  635. interdependent 9410
  636. Graves 9410
  637. neonatal 9410
  638. chafe 9410
  639. honoring 9410
  640. realtor 9410
  641. elite 9410
  642. funereal 9410
  643. abrogating 9410
  644. sorters 9410
  645. Conley 9410
  646. lectured 9410
  647. Abraham 9410
  648. Hawaii 9410
  649. cage 9410
  650. hushes 9410
  651. Simla 9410
  652. reporters 9410
  653. Dutchman 9410
  654. descendants 9410
  655. groupings 9410
  656. dissociate 9410
  657. coexist 9410
  658. Beebe 9410
  659. Taoism 9410
  660. Connally 9410
  661. fetched 9410
  662. checkpoints 9410
  663. rusting 9410
  664. galling 9410
  665. obliterates 9410
  666. traitor 9410
  667. resumes 9410
  668. analyzable 9410
  669. terminator 9410
  670. gritty 9410
  671. firearm 9410
  672. minima 9410
  673. Selfridge 9410
  674. disable 9410
  675. witchcraft 9410
  676. betroth 9410
  677. Manhattanize 9410
  678. imprint 9410
  679. peeked 9410
  680. swelling 9410
  681. interrelationships 9410
  682. riser 9410
  683. Gandhian 9410
  684. peacock 9410
  685. bee 9410
  686. kanji 9410
  687. dental 9410
  688. scarf 9410
  689. chasm 9410
  690. insolence 9410
  691. syndicate 9410
  692. alike 9410
  693. imperial 9410
  694. convulsion 9410
  695. railway 9410
  696. validate 9410
  697. normalizes 9410
  698. comprehensive 9410
  699. chewing 9410
  700. denizen 9410
  701. schemer 9410
  702. chronicle 9410
  703. Kline 9410
  704. Anatole 9410
  705. partridges 9410
  706. brunch 9410
  707. recruited 9410
  708. dimensions 9410
  709. Chicana 9410
  710. announced 9410
  711. praised 9410
  712. employing 9410
  713. linear 9410
  714. quagmire 9410
  715. western 9410
  716. relishing 9410
  717. serving 9410
  718. scheduling 9410
  719. lore 9410
  720. eventful 9410
  721. arteriole 9410
  722. disentangle 9410
  723. cured 9410
  724. Fenton 9410
  725. avoidable 9410
  726. drains 9410
  727. detectably 9410
  728. husky 9410
  729. impelling 9410
  730. undoes 9410
  731. evened 9410
  732. squeezes 9410
  733. destroyer 9410
  734. rudeness 9410
  735. beaner 9410
  736. boorish 9410
  737. Everhart 9410
  738. encompass 9410
  739. mushrooms 9410
  740. Alison 9410
  741. externally 9410
  742. pellagra 9410
  743. cult 9410
  744. creek 9410
  745. Huffman 9410
  746. Majorca 9410
  747. governing 9410
  748. gadfly 9410
  749. reassigned 9410
  750. intentness 9410
  751. craziness 9410
  752. psychic 9410
  753. squabbled 9410
  754. burlesque 9410
  755. capped 9410
  756. extracted 9410
  757. DiMaggio 9410
  758. exclamation 9410
  759. subdirectory 9410
  760. Gothicism 9410
  761. feminine 9410
  762. metaphysically 9410
  763. sanding 9410
  764. Miltonism 9410
  765. freakish 9410
  766. index 9410
  767. straight 9410
  768. flurried 9410
  769. denotative 9410
  770. coming 9410
  771. commencements 9410
  772. gentleman 9410
  773. gifted 9410
  774. Shanghais 9410
  775. sportswriting 9410
  776. sloping 9410
  777. navies 9410
  778. leaflet 9410
  779. shooter 9410
  780. Joplin 9410
  781. babies 9410
  782. assails 9410
  783. admiring 9410
  784. swaying 9410
  785. Goldstine 9410
  786. fitting 9410
  787. Norwalk 9410
  788. analogy 9410
  789. deludes 9410
  790. cokes 9410
  791. Clayton 9410
  792. exhausts 9410
  793. causality 9410
  794. sating 9410
  795. icon 9410
  796. throttles 9410
  797. communicants 9410
  798. dehydrate 9410
  799. priceless 9410
  800. publicly 9410
  801. incidentals 9410
  802. commonplace 9410
  803. mumbles 9410
  804. furthermore 9410
  805. cautioned 9410
  806. parametrized 9410
  807. registration 9410
  808. sadly 9410
  809. positioning 9410
  810. babysitting 9410
  811. eternal 9410
  812. hoarder 9410
  813. congregates 9410
  814. rains 9410
  815. workers 9410
  816. sags 9410
  817. unplug 9410
  818. garage 9410
  819. boulder 9410
  820. specifics 9410
  821. Teresa 9410
  822. Winsett 9410
  823. convenient 9410
  824. buckboards 9410
  825. amenities 9410
  826. resplendent 9410
  827. sews 9410
  828. participated 9410
  829. Simon 9410
  830. certificates 9410
  831. Fitzpatrick 9410
  832. Evanston 9410
  833. misted 9410
  834. textures 9410
  835. save 9410
  836. count 9410
  837. rightful 9410
  838. chaperone 9410
  839. Lizzy 9410
  840. clenched 9410
  841. effortlessly 9410
  842. accessed 9410
  843. beaters 9410
  844. Hornblower 9410
  845. vests 9410
  846. indulgences 9410
  847. infallibly 9410
  848. unwilling 9410
  849. excrete 9410
  850. spools 9410
  851. crunches 9410
  852. overestimating 9410
  853. ineffective 9410
  854. humiliation 9410
  855. sophomore 9410
  856. star 9410
  857. rifles 9410
  858. dialysis 9410
  859. arriving 9410
  860. indulge 9410
  861. clockers 9410
  862. languages 9410
  863. Antarctica 9410
  864. percentage 9410
  865. ceiling 9410
  866. specification 9410
  867. regimented 9410
  868. ciphers 9410
  869. pictures 9410
  870. serpents 9410
  871. allot 9410
  872. realized 9410
  873. mayoral 9410
  874. opaquely 9410
  875. hostess 9410
  876. fiftieth 9410
  877. incorrectly 9410
  878. decomposition 9410
  879. stranglings 9410
  880. mixture 9410
  881. electroencephalography 9410
  882. similarities 9410
  883. charges 9410
  884. freest 9410
  885. Greenberg 9410
  886. tinting 9410
  887. expelled 9410
  888. warm 9410
  889. smoothed 9410
  890. deductions 9410
  891. Romano 9410
  892. bitterroot 9410
  893. corset 9410
  894. securing 9410
  895. environing 9410
  896. cute 9410
  897. Crays 9410
  898. heiress 9410
  899. inform 9410
  900. avenge 9410
  901. universals 9410
  902. Kinsey 9410
  903. ravines 9410
  904. bestseller 9410
  905. equilibrium 9410
  906. extents 9410
  907. relatively 9410
  908. pressure 9410
  909. critiques 9410
  910. befouled 9410
  911. rightfully 9410
  912. mechanizing 9410
  913. Latinizes 9410
  914. timesharing 9410
  915. Aden 9410
  916. embassies 9410
  917. males 9410
  918. shapelessly 9410
  919. mastering 9410
  920. Newtonian 9410
  921. finishers 9410
  922. abates 9410
  923. teem 9410
  924. kiting 9410
  925. stodgy 9410
  926. feed 9410
  927. guitars 9410
  928. airships 9410
  929. store 9410
  930. denounces 9410
  931. Pyle 9410
  932. Saxony 9410
  933. serializations 9410
  934. Peruvian 9410
  935. taxonomically 9410
  936. kingdom 9410
  937. stint 9410
  938. Sault 9410
  939. faithful 9410
  940. Ganymede 9410
  941. tidiness 9410
  942. gainful 9410
  943. contrary 9410
  944. Tipperary 9410
  945. tropics 9410
  946. theorizers 9410
  947. renew 9410
  948. already 9410
  949. terminal 9410
  950. Hegelian 9410
  951. hypothesizer 9410
  952. warningly 9410
  953. journalizing 9410
  954. nested 9410
  955. Lars 9410
  956. saplings 9410
  957. foothill 9410
  958. labeled 9410
  959. imperiously 9410
  960. reporters 9410
  961. furnishings 9410
  962. precipitable 9410
  963. discounts 9410
  964. excises 9410
  965. Stalin 9410
  966. despot 9410
  967. ripeness 9410
  968. Arabia 9410
  969. unruly 9410
  970. mournfulness 9410
  971. boom 9410
  972. slaughter 9410
  973. Sabine 9410
  974. handy 9410
  975. rural 9410
  976. organizer 9410
  977. shipyard 9410
  978. civics 9410
  979. inaccuracy 9410
  980. rules 9410
  981. juveniles 9410
  982. comprised 9410
  983. investigations 9410
  984. stabilizes 9410
  985. seminaries 9410
  986. Hunter 9410
  987. sporty 9410
  988. test 9410
  989. weasels 9410
  990. CERN 9410
  991. tempering 9410
  992. afore 9410
  993. Galatean 9410
  994. techniques 9410
  995. error 9410
  996. veranda 9410
  997. severely 9410
  998. Cassites 9410
  999. forthcoming 9410
  1000. guides 9410
  1001. vanish 9410
  1002. lied 9410
  1003. sawtooth 9410
  1004. fated 9410
  1005. gradually 9410
  1006. widens 9410
  1007. preclude 9410
  1008. evenhandedly 9410
  1009. percentage 9410
  1010. disobedience 9410
  1011. humility 9410
  1012. gleaning 9410
  1013. petted 9410
  1014. bloater 9410
  1015. minion 9410
  1016. marginal 9410
  1017. apiary 9410
  1018. measures 9410
  1019. precaution 9410
  1020. repelled 9410
  1021. primary 9410
  1022. coverings 9410
  1023. Artemia 9410
  1024. navigate 9410
  1025. spatial 9410
  1026. Gurkha 9410
  1027. meanwhile 9410
  1028. Melinda 9410
  1029. Butterfield 9410
  1030. Aldrich 9410
  1031. previewing 9410
  1032. glut 9410
  1033. unaffected 9410
  1034. inmate 9410
  1035. mineral 9410
  1036. impending 9410
  1037. meditation 9410
  1038. ideas 9410
  1039. miniaturizes 9410
  1040. lewdly 9410
  1041. title 9410
  1042. youthfulness 9410
  1043. creak 9410
  1044. Chippewa 9410
  1045. clamored 9410
  1046. freezes 9410
  1047. forgivably 9410
  1048. reduce 9410
  1049. McGovern 9410
  1050. Nazis 9410
  1051. epistle 9410
  1052. socializes 9410
  1053. conceptions 9410
  1054. Kevin 9410
  1055. uncovering 9410
  1056. chews 9410
  1057. appendixes 9410
  1058. appendixes 9410
  1059. appendixes 9410
  1060. appendixes 9410
  1061. appendixes 9410
  1062. appendixes 9410
  1063. raining 9410
  1064. infest 9410
  1065. compartment 9410
  1066. minting 9410
  1067. ducks 9410
  1068. roped 9410
  1069. waltz 9410
  1070. Lillian 9410
  1071. repressions 9410
  1072. chillingly 9410
  1073. noncritical 9410
  1074. lithograph 9410
  1075. spongers 9410
  1076. parenthood 9410
  1077. posed 9410
  1078. instruments 9410
  1079. filial 9410
  1080. fixedly 9410
  1081. relives 9410
  1082. Pandora 9410
  1083. watering 9410
  1084. ungrateful 9410
  1085. secures 9410
  1086. poison 9410
  1087. dusted 9410
  1088. encompasses 9410
  1089. presentation 9410
  1090. Kantian 9410
  1091. fld3 period price price2
  1092. admonishing 1002 28357832 8723648
  1093. analyzable 1002 28357832 8723648
  1094. annihilates 1001 5987435 234724
  1095. Antares 1002 28357832 8723648
  1096. astound 1001 5987435 234724
  1097. audiology 1001 5987435 234724
  1098. Augustine 1002 28357832 8723648
  1099. Baird 1002 28357832 8723648
  1100. bewilderingly 1001 5987435 234724
  1101. breaking 1001 5987435 234724
  1102. Conley 1001 5987435 234724
  1103. dentally 1002 28357832 8723648
  1104. dissociate 1002 28357832 8723648
  1105. elite 1001 5987435 234724
  1106. eschew 1001 5987435 234724
  1107. Eulerian 1001 5987435 234724
  1108. flanking 1001 5987435 234724
  1109. foldout 1002 28357832 8723648
  1110. funereal 1002 28357832 8723648
  1111. galling 1002 28357832 8723648
  1112. Graves 1001 5987435 234724
  1113. grazing 1001 5987435 234724
  1114. groupings 1001 5987435 234724
  1115. handgun 1001 5987435 234724
  1116. humility 1002 28357832 8723648
  1117. impulsive 1002 28357832 8723648
  1118. inch 1001 5987435 234724
  1119. intelligibility 1001 5987435 234724
  1120. jarring 1001 5987435 234724
  1121. lawgiver 1001 5987435 234724
  1122. lectured 1002 28357832 8723648
  1123. Merritt 1002 28357832 8723648
  1124. neonatal 1001 5987435 234724
  1125. offload 1002 28357832 8723648
  1126. parters 1002 28357832 8723648
  1127. pityingly 1002 28357832 8723648
  1128. puddings 1002 28357832 8723648
  1129. Punjab 1001 5987435 234724
  1130. quitter 1002 28357832 8723648
  1131. realtor 1001 5987435 234724
  1132. relaxing 1001 5987435 234724
  1133. repetitions 1001 5987435 234724
  1134. resumes 1001 5987435 234724
  1135. Romans 1002 28357832 8723648
  1136. rusting 1001 5987435 234724
  1137. scholastics 1001 5987435 234724
  1138. skulking 1002 28357832 8723648
  1139. stated 1002 28357832 8723648
  1140. suites 1002 28357832 8723648
  1141. sureties 1001 5987435 234724
  1142. testicle 1002 28357832 8723648
  1143. tinily 1002 28357832 8723648
  1144. tragedies 1001 5987435 234724
  1145. trimmings 1001 5987435 234724
  1146. vacuuming 1001 5987435 234724
  1147. ventilate 1001 5987435 234724
  1148. wallet 1001 5987435 234724
  1149. Weissmuller 1002 28357832 8723648
  1150. Wotan 1002 28357832 8723648
  1151. fld1 fld3 period price price2
  1152. 018201 relaxing 1001 5987435 234724
  1153. 018601 vacuuming 1001 5987435 234724
  1154. 018801 inch 1001 5987435 234724
  1155. 018811 repetitions 1001 5987435 234724
  1156. companynr companyname
  1157. 00 Unknown
  1158. 29 company 1
  1159. 34 company 2
  1160. 36 company 3
  1161. 37 company 4
  1162. 40 company 5
  1163. 41 company 6
  1164. 50 company 11
  1165. 53 company 7
  1166. 58 company 8
  1167. 65 company 9
  1168. 68 company 10
  1169. companynr companyname
  1170. 00 Unknown
  1171. 29 company 1
  1172. 34 company 2
  1173. 36 company 3
  1174. 37 company 4
  1175. 40 company 5
  1176. 41 company 6
  1177. 50 company 11
  1178. 53 company 7
  1179. 58 company 8
  1180. 65 company 9
  1181. 68 company 10
  1182. Period Varor_period Period Varor_period
  1183. 9410 9412 9410 9412
  1184. fld1 fld1
  1185. 250501 250501
  1186. 250502 250501
  1187. 250503 250501
  1188. 250504 250501
  1189. 250505 250501
  1190. 250501 250502
  1191. 250502 250502
  1192. 250503 250502
  1193. 250504 250502
  1194. 250505 250502
  1195. 250501 250503
  1196. 250502 250503
  1197. 250503 250503
  1198. 250504 250503
  1199. 250505 250503
  1200. 250501 250504
  1201. 250502 250504
  1202. 250503 250504
  1203. 250504 250504
  1204. 250505 250504
  1205. 250501 250505
  1206. 250502 250505
  1207. 250503 250505
  1208. 250504 250505
  1209. 250505 250505
  1210. companynr companyname
  1211. table type possible_keys key key_len ref rows Extra
  1212. t2 ALL NULL NULL NULL NULL 1199
  1213. t4 eq_ref PRIMARY PRIMARY 1 t2.companynr 1 where used; Not exists
  1214. table type possible_keys key key_len ref rows Extra
  1215. t4 ALL NULL NULL NULL NULL 12
  1216. t2 ALL NULL NULL NULL NULL 1199 where used; Not exists
  1217. companynr companynr
  1218. 37 36
  1219. 41 40
  1220. table type possible_keys key key_len ref rows Extra
  1221. t2 ALL NULL NULL NULL NULL 1199 Using temporary
  1222. t4 index NULL PRIMARY 1 NULL 12 where used; Using index
  1223. fld1 companynr fld3 period
  1224. 038008 37 reporters 1008
  1225. 038208 37 Selfridge 1008
  1226. fld1 companynr fld3 period
  1227. 038008 37 reporters 1008
  1228. 038208 37 Selfridge 1008
  1229. fld1 companynr fld3 period
  1230. 038008 37 reporters 1008
  1231. 038208 37 Selfridge 1008
  1232. period
  1233. 9410
  1234. period
  1235. 9410
  1236. fld1
  1237. 250501
  1238. 250502
  1239. 250503
  1240. 250505
  1241. fld1
  1242. 250502
  1243. 250503
  1244. fld1
  1245. 250502
  1246. 250503
  1247. 250504
  1248. fld3
  1249. label
  1250. labeled
  1251. labeled
  1252. landslide
  1253. laterally
  1254. leaflet
  1255. lewdly
  1256. Lillian
  1257. luckily
  1258. count(*)
  1259. 1
  1260. companynr count(*) sum(fld1)
  1261. 00 82 10355753
  1262. 29 95 14473298
  1263. 34 70 17788966
  1264. 36 215 22786296
  1265. 37 588 83602098
  1266. 40 37 6618386
  1267. 41 52 12816335
  1268. 50 11 1595438
  1269. 53 4 793210
  1270. 58 23 2254293
  1271. 65 10 2284055
  1272. 68 12 3097288
  1273. companynr count(*)
  1274. 68 12
  1275. 65 10
  1276. 58 23
  1277. 53 4
  1278. 50 11
  1279. count(*) min(fld4) max(fld4) sum(fld1) avg(fld1) std(fld1)
  1280. 70 absentee vest 17788966 254128.0857 3272.5940
  1281. companynr count(*) min(fld4) max(fld4) sum(fld1) avg(fld1) std(fld1)
  1282. 00 82 Anthony windmills 10355753 126289.6707 115550.9757
  1283. 29 95 abut wetness 14473298 152350.5053 8368.5480
  1284. 34 70 absentee vest 17788966 254128.0857 3272.5940
  1285. companynr t2nr count(price) sum(price) min(price) max(price) avg(price)
  1286. 37 1 1 5987435 5987435 5987435 5987435.0000
  1287. 37 2 1 28357832 28357832 28357832 28357832.0000
  1288. 37 3 1 39654943 39654943 39654943 39654943.0000
  1289. 37 11 1 5987435 5987435 5987435 5987435.0000
  1290. 37 12 1 28357832 28357832 28357832 28357832.0000
  1291. 37 13 1 39654943 39654943 39654943 39654943.0000
  1292. 37 21 1 5987435 5987435 5987435 5987435.0000
  1293. 37 22 1 28357832 28357832 28357832 28357832.0000
  1294. 37 23 1 39654943 39654943 39654943 39654943.0000
  1295. 37 31 1 5987435 5987435 5987435 5987435.0000
  1296. companynr t2nr count(price) sum(price) min(price) max(price) avg(price)
  1297. 37 1 1 5987435 5987435 5987435 5987435.0000
  1298. 37 2 1 28357832 28357832 28357832 28357832.0000
  1299. 37 3 1 39654943 39654943 39654943 39654943.0000
  1300. 37 11 1 5987435 5987435 5987435 5987435.0000
  1301. 37 12 1 28357832 28357832 28357832 28357832.0000
  1302. 37 13 1 39654943 39654943 39654943 39654943.0000
  1303. 37 21 1 5987435 5987435 5987435 5987435.0000
  1304. 37 22 1 28357832 28357832 28357832 28357832.0000
  1305. 37 23 1 39654943 39654943 39654943 39654943.0000
  1306. 37 31 1 5987435 5987435 5987435 5987435.0000
  1307. companynr count(price) sum(price) min(price) max(price) avg(price)
  1308. 37 12543 309394878010 5987435 39654943 24666736.6667
  1309. 78 8362 414611089292 726498 98439034 49582766.0000
  1310. 101 4181 3489454238 834598 834598 834598.0000
  1311. 154 4181 4112197254950 983543950 983543950 983543950.0000
  1312. 311 4181 979599938 234298 234298 234298.0000
  1313. 447 4181 9929180954 2374834 2374834 2374834.0000
  1314. 512 4181 3288532102 786542 786542 786542.0000
  1315. mod(companynr,10)
  1316. 0
  1317. 9
  1318. 4
  1319. 6
  1320. 7
  1321. 1
  1322. 3
  1323. 8
  1324. 5
  1325. 1
  1326. 1
  1327. count(distinct fld1)
  1328. 1199
  1329. companynr count(distinct fld1)
  1330. 00 82
  1331. 29 95
  1332. 34 70
  1333. 36 215
  1334. 37 588
  1335. 40 37
  1336. 41 52
  1337. 50 11
  1338. 53 4
  1339. 58 23
  1340. 65 10
  1341. 68 12
  1342. companynr count(*)
  1343. 00 82
  1344. 29 95
  1345. 34 70
  1346. 36 215
  1347. 37 588
  1348. 40 37
  1349. 41 52
  1350. 50 11
  1351. 53 4
  1352. 58 23
  1353. 65 10
  1354. 68 12
  1355. companynr count(distinct concat(fld1,repeat(65,1000)))
  1356. 00 82
  1357. 29 95
  1358. 34 70
  1359. 36 215
  1360. 37 588
  1361. 40 37
  1362. 41 52
  1363. 50 11
  1364. 53 4
  1365. 58 23
  1366. 65 10
  1367. 68 12
  1368. companynr count(distinct concat(fld1,repeat(65,200)))
  1369. 00 82
  1370. 29 95
  1371. 34 70
  1372. 36 215
  1373. 37 588
  1374. 40 37
  1375. 41 52
  1376. 50 11
  1377. 53 4
  1378. 58 23
  1379. 65 10
  1380. 68 12
  1381. companynr count(distinct floor(fld1/100))
  1382. 00 47
  1383. 29 35
  1384. 34 14
  1385. 36 69
  1386. 37 108
  1387. 40 16
  1388. 41 11
  1389. 50 9
  1390. 53 1
  1391. 58 1
  1392. 65 1
  1393. 68 1
  1394. companynr count(distinct concat(repeat(65,1000),floor(fld1/100)))
  1395. 00 47
  1396. 29 35
  1397. 34 14
  1398. 36 69
  1399. 37 108
  1400. 40 16
  1401. 41 11
  1402. 50 9
  1403. 53 1
  1404. 58 1
  1405. 65 1
  1406. 68 1
  1407. sum(fld1) fld3
  1408. 11402 Romans
  1409. name count(*)
  1410. cloakroom 4181
  1411. name count(*)
  1412. cloakroom 4181
  1413. count(*)
  1414. 4181
  1415. name count(*)
  1416. cloakroom 4181
  1417. name count(*)
  1418. extramarital 4181
  1419. gazer 4181
  1420. gems 4181
  1421. Iranizes 4181
  1422. spates 4181
  1423. tucked 4181
  1424. violinist 4181
  1425. fld3 count(*)
  1426. spates 4181
  1427. companynr|0 companyname
  1428. 0 Unknown
  1429. 29 company 1
  1430. 34 company 2
  1431. 36 company 3
  1432. 37 company 4
  1433. 40 company 5
  1434. 41 company 6
  1435. 50 company 11
  1436. 53 company 7
  1437. 58 company 8
  1438. 65 company 9
  1439. 68 company 10
  1440. companynr companyname count(*)
  1441. 29 company 1 95
  1442. 68 company 10 12
  1443. 50 company 11 11
  1444. 34 company 2 70
  1445. 36 company 3 215
  1446. 37 company 4 588
  1447. 40 company 5 37
  1448. 41 company 6 52
  1449. 53 company 7 4
  1450. 58 company 8 23
  1451. 65 company 9 10
  1452. 00 Unknown 82
  1453. fld1 count(*)
  1454. 158402 4181
  1455. sum(Period)/count(*)
  1456. 9410.00
  1457. companynr count sum diff func
  1458. 37 12543 309394878010 0.0000 464091
  1459. 78 8362 414611089292 0.0000 652236
  1460. 101 4181 3489454238 0.0000 422281
  1461. 154 4181 4112197254950 0.0000 643874
  1462. 311 4181 979599938 0.0000 1300291
  1463. 447 4181 9929180954 0.0000 1868907
  1464. 512 4181 3288532102 0.0000 2140672
  1465. companynr avg
  1466. 154 983543950.00
  1467. companynr count(*)
  1468. 37 588
  1469. 36 215
  1470. 29 95
  1471. 00 82
  1472. 34 70
  1473. 41 52
  1474. 40 37
  1475. 58 23
  1476. 68 12
  1477. 50 11
  1478. 65 10
  1479. 53 4
  1480. companynr count(*)
  1481. 41 52
  1482. 58 23
  1483. 68 12
  1484. 50 11
  1485. 65 10
  1486. 53 4
  1487. fld4 fld1 count(price) sum(price) min(price) max(price) avg(price)
  1488. teethe 000001 1 5987435 5987435 5987435 5987435.0000
  1489. dreaded 011401 1 5987435 5987435 5987435 5987435.0000
  1490. scholastics 011402 1 28357832 28357832 28357832 28357832.0000
  1491. audiology 011403 1 39654943 39654943 39654943 39654943.0000
  1492. wallet 011501 1 5987435 5987435 5987435 5987435.0000
  1493. parters 011701 1 5987435 5987435 5987435 5987435.0000
  1494. eschew 011702 1 28357832 28357832 28357832 28357832.0000
  1495. quitter 011703 1 39654943 39654943 39654943 39654943.0000
  1496. neat 012001 1 5987435 5987435 5987435 5987435.0000
  1497. Steinberg 012003 1 39654943 39654943 39654943 39654943.0000
  1498. balled 012301 1 5987435 5987435 5987435 5987435.0000
  1499. persist 012302 1 28357832 28357832 28357832 28357832.0000
  1500. attainments 012303 1 39654943 39654943 39654943 39654943.0000
  1501. capably 012501 1 5987435 5987435 5987435 5987435.0000
  1502. impulsive 012602 1 28357832 28357832 28357832 28357832.0000
  1503. starlet 012603 1 39654943 39654943 39654943 39654943.0000
  1504. featherweight 012701 1 5987435 5987435 5987435 5987435.0000
  1505. pessimist 012702 1 28357832 28357832 28357832 28357832.0000
  1506. daughter 012703 1 39654943 39654943 39654943 39654943.0000
  1507. lawgiver 013601 1 5987435 5987435 5987435 5987435.0000
  1508. stated 013602 1 28357832 28357832 28357832 28357832.0000
  1509. readable 013603 1 39654943 39654943 39654943 39654943.0000
  1510. testicle 013801 1 5987435 5987435 5987435 5987435.0000
  1511. Parsifal 013802 1 28357832 28357832 28357832 28357832.0000
  1512. leavings 013803 1 39654943 39654943 39654943 39654943.0000
  1513. squeaking 013901 1 5987435 5987435 5987435 5987435.0000
  1514. contrasted 016001 1 5987435 5987435 5987435 5987435.0000
  1515. leftover 016201 1 5987435 5987435 5987435 5987435.0000
  1516. whiteners 016202 1 28357832 28357832 28357832 28357832.0000
  1517. erases 016301 1 5987435 5987435 5987435 5987435.0000
  1518. Punjab 016302 1 28357832 28357832 28357832 28357832.0000
  1519. Merritt 016303 1 39654943 39654943 39654943 39654943.0000
  1520. sweetish 018001 1 5987435 5987435 5987435 5987435.0000
  1521. dogging 018002 1 28357832 28357832 28357832 28357832.0000
  1522. scornfully 018003 1 39654943 39654943 39654943 39654943.0000
  1523. fetters 018012 1 28357832 28357832 28357832 28357832.0000
  1524. bivalves 018013 1 39654943 39654943 39654943 39654943.0000
  1525. skulking 018021 1 5987435 5987435 5987435 5987435.0000
  1526. flint 018022 1 28357832 28357832 28357832 28357832.0000
  1527. flopping 018023 1 39654943 39654943 39654943 39654943.0000
  1528. Judas 018032 1 28357832 28357832 28357832 28357832.0000
  1529. vacuuming 018033 1 39654943 39654943 39654943 39654943.0000
  1530. medical 018041 1 5987435 5987435 5987435 5987435.0000
  1531. bloodbath 018042 1 28357832 28357832 28357832 28357832.0000
  1532. subschema 018043 1 39654943 39654943 39654943 39654943.0000
  1533. interdependent 018051 1 5987435 5987435 5987435 5987435.0000
  1534. Graves 018052 1 28357832 28357832 28357832 28357832.0000
  1535. neonatal 018053 1 39654943 39654943 39654943 39654943.0000
  1536. sorters 018061 1 5987435 5987435 5987435 5987435.0000
  1537. epistle 018062 1 28357832 28357832 28357832 28357832.0000
  1538. Conley 018101 1 5987435 5987435 5987435 5987435.0000
  1539. lectured 018102 1 28357832 28357832 28357832 28357832.0000
  1540. Abraham 018103 1 39654943 39654943 39654943 39654943.0000
  1541. cage 018201 1 5987435 5987435 5987435 5987435.0000
  1542. hushes 018202 1 28357832 28357832 28357832 28357832.0000
  1543. Simla 018402 1 28357832 28357832 28357832 28357832.0000
  1544. reporters 018403 1 39654943 39654943 39654943 39654943.0000
  1545. coexist 018601 1 5987435 5987435 5987435 5987435.0000
  1546. Beebe 018602 1 28357832 28357832 28357832 28357832.0000
  1547. Taoism 018603 1 39654943 39654943 39654943 39654943.0000
  1548. Connally 018801 1 5987435 5987435 5987435 5987435.0000
  1549. fetched 018802 1 28357832 28357832 28357832 28357832.0000
  1550. checkpoints 018803 1 39654943 39654943 39654943 39654943.0000
  1551. gritty 018811 1 5987435 5987435 5987435 5987435.0000
  1552. firearm 018812 1 28357832 28357832 28357832 28357832.0000
  1553. minima 019101 1 5987435 5987435 5987435 5987435.0000
  1554. Selfridge 019102 1 28357832 28357832 28357832 28357832.0000
  1555. disable 019103 1 39654943 39654943 39654943 39654943.0000
  1556. witchcraft 019201 1 5987435 5987435 5987435 5987435.0000
  1557. betroth 030501 1 5987435 5987435 5987435 5987435.0000
  1558. Manhattanize 030502 1 28357832 28357832 28357832 28357832.0000
  1559. imprint 030503 1 39654943 39654943 39654943 39654943.0000
  1560. swelling 031901 1 5987435 5987435 5987435 5987435.0000
  1561. interrelationships 036001 1 5987435 5987435 5987435 5987435.0000
  1562. riser 036002 1 28357832 28357832 28357832 28357832.0000
  1563. bee 038001 1 5987435 5987435 5987435 5987435.0000
  1564. kanji 038002 1 28357832 28357832 28357832 28357832.0000
  1565. dental 038003 1 39654943 39654943 39654943 39654943.0000
  1566. railway 038011 1 5987435 5987435 5987435 5987435.0000
  1567. validate 038012 1 28357832 28357832 28357832 28357832.0000
  1568. normalizes 038013 1 39654943 39654943 39654943 39654943.0000
  1569. Kline 038101 1 5987435 5987435 5987435 5987435.0000
  1570. Anatole 038102 1 28357832 28357832 28357832 28357832.0000
  1571. partridges 038103 1 39654943 39654943 39654943 39654943.0000
  1572. recruited 038201 1 5987435 5987435 5987435 5987435.0000
  1573. dimensions 038202 1 28357832 28357832 28357832 28357832.0000
  1574. Chicana 038203 1 39654943 39654943 39654943 39654943.0000
  1575. companynr fld3 sum(price)
  1576. 512 boat 786542
  1577. 512 capably 786542
  1578. 512 cupboard 786542
  1579. 512 decliner 786542
  1580. 512 descendants 786542
  1581. 512 dopers 786542
  1582. 512 erases 786542
  1583. 512 Micronesia 786542
  1584. 512 Miles 786542
  1585. 512 skies 786542
  1586. companynr count(*) min(fld3) max(fld3) sum(price) avg(price)
  1587. 00 1 Omaha Omaha 5987435 5987435.0000
  1588. 36 1 dubbed dubbed 28357832 28357832.0000
  1589. 37 83 Abraham Wotan 1908978016 22999735.1325
  1590. 50 2 scribbled tapestry 68012775 34006387.5000
  1591. t3.companynr+0 t2nr fld3 sum(price)
  1592. 37 1 Omaha 5987435
  1593. 37 11401 breaking 5987435
  1594. 37 11402 Romans 28357832
  1595. 37 11403 intercepted 39654943
  1596. 37 11501 bewilderingly 5987435
  1597. 37 11701 astound 5987435
  1598. 37 11702 admonishing 28357832
  1599. 37 11703 sumac 39654943
  1600. 37 12001 flanking 5987435
  1601. 37 12003 combed 39654943
  1602. 37 12301 Eulerian 5987435
  1603. 37 12302 dubbed 28357832
  1604. 37 12303 Kane 39654943
  1605. 37 12501 annihilates 5987435
  1606. 37 12602 Wotan 28357832
  1607. 37 12603 snatching 39654943
  1608. 37 12701 grazing 5987435
  1609. 37 12702 Baird 28357832
  1610. 37 12703 celery 39654943
  1611. 37 13601 handgun 5987435
  1612. 37 13602 foldout 28357832
  1613. 37 13603 mystic 39654943
  1614. 37 13801 intelligibility 5987435
  1615. 37 13802 Augustine 28357832
  1616. 37 13803 teethe 39654943
  1617. 37 13901 scholastics 5987435
  1618. 37 16001 audiology 5987435
  1619. 37 16201 wallet 5987435
  1620. 37 16202 parters 28357832
  1621. 37 16301 eschew 5987435
  1622. 37 16302 quitter 28357832
  1623. 37 16303 neat 39654943
  1624. 37 18001 jarring 5987435
  1625. 37 18002 tinily 28357832
  1626. 37 18003 balled 39654943
  1627. 37 18012 impulsive 28357832
  1628. 37 18013 starlet 39654943
  1629. 37 18021 lawgiver 5987435
  1630. 37 18022 stated 28357832
  1631. 37 18023 readable 39654943
  1632. 37 18032 testicle 28357832
  1633. 37 18033 Parsifal 39654943
  1634. 37 18041 Punjab 5987435
  1635. 37 18042 Merritt 28357832
  1636. 37 18043 Quixotism 39654943
  1637. 37 18051 sureties 5987435
  1638. 37 18052 puddings 28357832
  1639. 37 18053 tapestry 39654943
  1640. 37 18061 trimmings 5987435
  1641. 37 18062 humility 28357832
  1642. 37 18101 tragedies 5987435
  1643. 37 18102 skulking 28357832
  1644. 37 18103 flint 39654943
  1645. 37 18201 relaxing 5987435
  1646. 37 18202 offload 28357832
  1647. 37 18402 suites 28357832
  1648. 37 18403 lists 39654943
  1649. 37 18601 vacuuming 5987435
  1650. 37 18602 dentally 28357832
  1651. 37 18603 humanness 39654943
  1652. 37 18801 inch 5987435
  1653. 37 18802 Weissmuller 28357832
  1654. 37 18803 irresponsibly 39654943
  1655. 37 18811 repetitions 5987435
  1656. 37 18812 Antares 28357832
  1657. 37 19101 ventilate 5987435
  1658. 37 19102 pityingly 28357832
  1659. 37 19103 interdependent 39654943
  1660. 37 19201 Graves 5987435
  1661. 37 30501 neonatal 5987435
  1662. 37 30502 scribbled 28357832
  1663. 37 30503 chafe 39654943
  1664. 37 31901 realtor 5987435
  1665. 37 36001 elite 5987435
  1666. 37 36002 funereal 28357832
  1667. 37 38001 Conley 5987435
  1668. 37 38002 lectured 28357832
  1669. 37 38003 Abraham 39654943
  1670. 37 38011 groupings 5987435
  1671. 37 38012 dissociate 28357832
  1672. 37 38013 coexist 39654943
  1673. 37 38101 rusting 5987435
  1674. 37 38102 galling 28357832
  1675. 37 38103 obliterates 39654943
  1676. 37 38201 resumes 5987435
  1677. 37 38202 analyzable 28357832
  1678. 37 38203 terminator 39654943
  1679. sum(price)
  1680. 234298
  1681. fld1 sum(price)
  1682. 038008 234298
  1683. Comment
  1684. Impossible WHERE
  1685. table type possible_keys key key_len ref rows Extra
  1686. t2 ALL NULL NULL NULL NULL 1199
  1687. companynr fld1
  1688. 34 250501
  1689. 34 250502
  1690. companynr fld1
  1691. 34 250501
  1692. 34 250502
  1693. companynr count sum
  1694. 00 82 10355753
  1695. 29 95 14473298
  1696. 34 70 17788966
  1697. 37 588 83602098
  1698. 41 52 12816335
  1699. companynr
  1700. 00
  1701. 29
  1702. 34
  1703. 37
  1704. 41
  1705. companynr companyname count(*)
  1706. 68 company 10 12
  1707. 50 company 11 11
  1708. 40 company 5 37
  1709. 41 company 6 52
  1710. 53 company 7 4
  1711. 58 company 8 23
  1712. 65 company 9 10
  1713. count(*)
  1714. 1199
  1715. count(*)
  1716. 387
  1717. min(fld1)
  1718. 98024
  1719. max(fld1)
  1720. 1232609
  1721. count(*)
  1722. 4181
  1723. count(*)
  1724. 4181
  1725. Comment
  1726. Select tables optimized away
  1727. min(fld1) max(fld1) count(*)
  1728. 0 1232609 1199
  1729. min(t2nr) max(t2nr)
  1730. 2115 2115
  1731. count(*) min(t2nr) max(t2nr)
  1732. 4181 4 41804
  1733. t2nr count(*)
  1734. 9 1
  1735. 19 1
  1736. 29 1
  1737. 39 1
  1738. 49 1
  1739. 59 1
  1740. 69 1
  1741. 79 1
  1742. 89 1
  1743. 99 1
  1744. 109 1
  1745. 119 1
  1746. 129 1
  1747. 139 1
  1748. 149 1
  1749. 159 1
  1750. 169 1
  1751. 179 1
  1752. 189 1
  1753. 199 1
  1754. max(t2nr)
  1755. 41807
  1756. period
  1757. 1001
  1758. period
  1759. 9410
  1760. Nuvarande period
  1761. 9410
  1762. ok_period
  1763. 9410
  1764. ok_period
  1765. 9410
  1766. summa
  1767. 2
  1768. Nuvarande period
  1769. 9410
  1770. Tables_in_test
  1771. t1
  1772. t2
  1773. t3
  1774. t4
  1775. Tables_in_test (s%)
  1776. Tables_in_test (t?)
  1777. Field Type Null Key Default Extra Privileges
  1778. auto int(11) PRI NULL auto_increment select,insert,update,references
  1779. fld1 int(6) unsigned zerofill UNI 000000 select,insert,update,references
  1780. companynr tinyint(2) unsigned zerofill 00 select,insert,update,references
  1781. fld3 char(30) MUL select,insert,update,references
  1782. fld4 char(35) select,insert,update,references
  1783. fld5 char(35) select,insert,update,references
  1784. fld6 char(4) select,insert,update,references
  1785. Field Type Null Key Default Extra Privileges
  1786. fld1 int(6) unsigned zerofill UNI 000000 select,insert,update,references
  1787. fld3 char(30) MUL select,insert,update,references
  1788. fld4 char(35) select,insert,update,references
  1789. fld5 char(35) select,insert,update,references
  1790. fld6 char(4) select,insert,update,references
  1791. Field Type Null Key Default Extra Privileges
  1792. Table Non_unique Key_name Seq_in_index Column_name Collation Cardinality Sub_part Packed Comment
  1793. t2 0 PRIMARY 1 auto A 1199 NULL NULL
  1794. t2 0 fld1 1 fld1 A 1199 NULL NULL
  1795. t2 1 fld3 1 fld3 A NULL NULL NULL