List:General Discussion« Previous MessageNext Message »
From:Horizon Date:January 13 2003 11:47am
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.

That's what I did, see original select statement:

mysql> select distinct atomtype from `gentradedb`.`gpatomdb` order by
atomtype;

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

Experiment how?

> Also, don't confuse the RANGE of values that the atomtype can be (0-255)
> if set to be UNSIGNED with the NUMBER OF ROWS in your output. The
> TINYINT is working. You have no values greater than 255 in there. You
> just have duplicates which gives you more rows than you were expecting I
> think. ;-)

I don't think I do, the database has several millions rows.

Thanks for pointing out the dups, isn't what select distinct is meant to do?

Terry

---------

>
> 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