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
>
