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