Category

Development Platform
Home > SourceCode/Document > Database system > MySQL > View Code
distinct.result
Package: mysql-3.23.35.tar.gz　[view]
Upload User: tsgydb
Upload Date: 2007-04-14
Package Size: 10674k
Code Size: 2k
Category:

MySQL

Development Platform:

Visual C++

distinct.result：Code Content
  1. id
  2. NULL
  3. -1
  4. 0
  5. 1
  6. 2
  7. 3
  8. 4
  9. 5
  10. 6
  11. 7
  12. 8
  13. 9
  14. 10
  15. id facility
  16. NULL NULL
  17. -1
  18. 0
  19. 1 /L
  20. 2 A01
  21. 3 ANC
  22. 4 F01
  23. 5 FBX
  24. 6 MT
  25. 7 P
  26. 8 RV
  27. 9 SRV
  28. 10 VMT
  29. id-5 facility
  30. NULL NULL
  31. -6
  32. -5
  33. -4 /L
  34. -3 A01
  35. -2 ANC
  36. -1 F01
  37. 0 FBX
  38. 1 MT
  39. 2 P
  40. 3 RV
  41. 4 SRV
  42. 5 VMT
  43. id concat(facility)
  44. NULL NULL
  45. -1
  46. 0
  47. 1 /L
  48. 2 A01
  49. 3 ANC
  50. 4 F01
  51. 5 FBX
  52. 6 MT
  53. 7 P
  54. 8 RV
  55. 9 SRV
  56. 10 VMT
  57. a max(id) b
  58. 10 10 VMT
  59. 9 9 SRV
  60. 8 8 RV
  61. 7 7 P
  62. 6 6 MT
  63. 5 5 FBX
  64. 4 4 F01
  65. 3 3 ANC
  66. 2 2 A01
  67. 1 1 /L
  68. -1 -1
  69. 0 0
  70. NULL NULL NULL
  71. grp count(*)
  72. 0 7
  73. 1 6
  74. FACILITY
  75. NULL
  77. /L
  78. A01
  79. ANC
  80. F01
  81. FBX
  82. MT
  83. P
  84. RV
  85. SRV
  86. VMT
  87. FACILITY
  88. NULL
  90. /L
  91. A01
  92. ANC
  93. F01
  94. FBX
  95. MT
  96. P
  97. RV
  98. SRV
  99. VMT
  100. count(*)
  101. 12
  102. count(facility)
  103. 12
  104. count(*)
  105. 13
  106. count(*)
  107. 1
  108. count(*)
  109. 0
  110. count(*)
  111. 12
  112. count(*)
  113. 1
  114. count(*)
  115. 12
  116. UserId
  117. UserId
  118. UserId
  119. UserId
  120. b
  121. 1
  122. table type possible_keys key key_len ref rows Extra
  123. t3 index a a 5 NULL 6 Using index; Using temporary
  124. t2 index a a 4 NULL 5 Using index; Distinct
  125. t1 eq_ref PRIMARY PRIMARY 4 t2.a 1 where used; Distinct
  126. a
  127. 1
  128. table type possible_keys key key_len ref rows Extra
  129. t1 index PRIMARY PRIMARY 4 NULL 2 Using index; Using temporary
  130. t3 ref a a 5 t1.a 10 Using index; Distinct
  131. a
  132. 1
  133. 2
  134. 1
  135. 1
  136. name
  137. aa
  138. ab
  139. name
  140. aa
  141. ab
  142. 1
  143. 1
  144. key_link_id link
  145. NULL NULL
  146. table type possible_keys key key_len ref rows Extra
  147. t1 index id id 4 NULL 2 Using index; Using temporary
  148. t2 index id id 8 NULL 1 Using index; Distinct
  149. t3 index id id 8 NULL 1 Using index; Distinct
  150. j_lj_t2 index id id 4 NULL 2 where used; Using index; Distinct
  151. t2_lj index id id 8 NULL 1 where used; Using index; Distinct
  152. j_lj_t3 index id id 4 NULL 2 where used; Using index; Distinct
  153. t3_lj index id id 8 NULL 1 where used; Using index; Distinct
  154. id
  155. 2
  156. a sec_to_time(sum(time_to_sec(t)))
  157. 1 00:06:15
  158. 1 00:36:30
  159. 1 00:36:30
  160. a sec_to_time(sum(time_to_sec(t)))
  161. 1 00:06:15
  162. 1 00:36:30
  163. a sec_to_time(sum(time_to_sec(t)))
  164. 1 00:06:15
  165. 1 00:36:30
  166. 1 00:36:30
  167. a sec_to_time(sum(time_to_sec(t)))
  168. 1 00:06:15
  169. 1 00:36:30