List:General Discussion« Previous MessageNext Message »
From:Daevid Vincent Date:January 13 2003 3:35am
Subject:RE: unexpected: 260 rows in set on a TINYINT
View as plain text  
I would suggest appending an "ORDER BY atomtype" first of all.

I say this because if you scan your results, you have duplicates...

|      165 |
|      166 |
|      167 |  <---
|      168 |
|      169 |
|      170 |
|      171 |
|      172 |
|      173 |
|      174 |
|      175 |
|      167 |  <---
|      175 |

So you prolly have other in there too.

You could also experiment with SELECT DISTINCT to remove any dupes from
your output.

DÆVID.

> -----Original Message-----
> From: Horizon [mailto:horizonx@stripped] 
> Sent: Saturday, January 11, 2003 7:46 PM
> To: Mysql List
> Subject: unexpected: 260 rows in set on a TINYINT
> 
> 
> mysql> select distinct atomtype from `gentradedb`.`gpatomdb`  order by
> atomtype;
> 
> +----------+
> | atomtype |
> +----------+
> |        0 |
> |        1 |
> |        2 |
> |        3 |
> |        4 |
> |        5 |
> |        6 |
> |        7 |
> |        8 |
> |        9 |
> |       10 |
> |       11 |
> |       12 |
> |       13 |
> |       14 |
> |       15 |
> |       16 |
> |       17 |
> |       18 |
> |       19 |
> |       20 |
> |       21 |
> |       22 |
> |       23 |
> |       24 |
> |       25 |
> |       26 |
> |       27 |
> |       28 |
> |       29 |
> |       30 |
> |       31 |
> |       32 |
> |       33 |
> |       34 |
> |       35 |
> |       36 |
> |       37 |
> |       38 |
> |       39 |
> |       40 |
> |       41 |
> |       42 |
> |       43 |
> |       44 |
> |       45 |
> |       46 |
> |       47 |
> |       48 |
> |       49 |
> |       50 |
> |       51 |
> |       52 |
> |       53 |
> |       54 |
> |       55 |
> |       56 |
> |       57 |
> |       58 |
> |       59 |
> |       60 |
> |       61 |
> |       62 |
> |       63 |
> |       64 |
> |       65 |
> |       66 |
> |       67 |
> |       68 |
> |       69 |
> |       70 |
> |       71 |
> |       72 |
> |       73 |
> |       74 |
> |       75 |
> |       76 |
> |       77 |
> |       78 |
> |       79 |
> |       80 |
> |       81 |
> |       82 |
> |       83 |
> |       84 |
> |       85 |
> |       86 |
> |       87 |
> |       88 |
> |       89 |
> |       90 |
> |       91 |
> |       92 |
> |       93 |
> |       94 |
> |       95 |
> |       96 |
> |       97 |
> |       98 |
> |       99 |
> |      100 |
> |      101 |
> |      102 |
> |      103 |
> |      104 |
> |      105 |
> |      106 |
> |      107 |
> |      108 |
> |      109 |
> |      110 |
> |      111 |
> |      112 |
> |      113 |
> |      114 |
> |      115 |
> |      116 |
> |      117 |
> |      118 |
> |      119 |
> |      120 |
> |      121 |
> |      122 |
> |      123 |
> |      124 |
> |      125 |
> |      126 |
> |      127 |
> |      128 |
> |      129 |
> |      130 |
> |      131 |
> |      132 |
> |      133 |
> |      134 |
> |      135 |
> |      136 |
> |      137 |
> |      138 |
> |      139 |
> |      140 |
> |      141 |
> |      142 |
> |      143 |
> |      144 |
> |      145 |
> |      146 |
> |      147 |
> |      148 |
> |      149 |
> |      150 |
> |      151 |
> |      152 |
> |      153 |
> |      154 |
> |      155 |
> |      156 |
> |      157 |
> |      158 |
> |      159 |
> |      160 |
> |      161 |
> |      162 |
> |      163 |
> |      164 |
> |      165 |
> |      166 |
> |      167 |
> |      168 |
> |      169 |
> |      170 |
> |      171 |
> |      172 |
> |      173 |
> |      174 |
> |      175 |
> |      167 |
> |      175 |
> |      176 |
> |      177 |
> |      178 |
> |      179 |
> |      180 |
> |      181 |
> |      182 |
> |      183 |
> |      184 |
> |      185 |
> |      186 |
> |      187 |
> |      188 |
> |      189 |
> |      190 |
> |      191 |
> |      192 |
> |      193 |
> |      194 |
> |      195 |
> |      196 |
> |      197 |
> |      198 |
> |      199 |
> |      200 |
> |      201 |
> |      202 |
> |      203 |
> |      204 |
> |      205 |
> |      206 |
> |      207 |
> |      208 |
> |      209 |
> |      210 |
> |      211 |
> |      212 |
> |      213 |
> |      214 |
> |      215 |
> |      216 |
> |      217 |
> |      218 |
> |      219 |
> |      220 |
> |      221 |
> |      222 |
> |      214 |
> |      222 |
> |      223 |
> |      224 |
> |      225 |
> |      226 |
> |      227 |
> |      228 |
> |      229 |
> |      230 |
> |      231 |
> |      232 |
> |      233 |
> |      234 |
> |      235 |
> |      236 |
> |      237 |
> |      238 |
> |      239 |
> |      240 |
> |      241 |
> |      242 |
> |      243 |
> |      244 |
> |      245 |
> |      246 |
> |      247 |
> |      248 |
> |      249 |
> |      250 |
> |      251 |
> |      252 |
> |      253 |
> |      254 |
> |      255 |
> +----------+
> 260 rows in set (6 min 53.71 sec)
> 
> 
> 
> ---------------------------------------------------------------------
> Before posting, please check:
>    http://www.mysql.com/manual.php   (the manual)
>    http://lists.mysql.com/           (the list archive)
> 
> To request this thread, e-mail <mysql-thread129675@stripped>
> To unsubscribe, e-mail 
> <mysql-unsubscribe-daevid=daevid.com@stripped>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
> 

Thread
unexpected: 260 rows in set on a TINYINTHorizon12 Jan
  • RE: unexpected: 260 rows in set on a TINYINTDaevid Vincent13 Jan
    • RE: unexpected: 260 rows in set on a TINYINTHorizon13 Jan
      • RE: unexpected: 260 rows in set on a TINYINTDaevid Vincent15 Jan
  • RE: unexpected: 260 rows in set on a TINYINTDaevid Vincent13 Jan