You know what? You are correct on both accounts. I completely overlooked what you had written as your SQL query and am a blind moron ;-)
Yeah, I dunno why you got whacky results then. It is true the TINYINT is still in it's range, so that part is working, so the issue is that the DISTINCT and/or the ORDER BY is not working. Out of curiousity, did you try it like gentradedb.gpatomdb instead of `gentradedb`.`gpatomdb` Mebbe the ` are confusing mySQL? > -----Original Message----- > From: Horizon [mailto:[EMAIL PROTECTED]] > Sent: Monday, January 13, 2003 3:48 AM > To: Daevid Vincent > Cc: Mysql List > Subject: RE: unexpected: 260 rows in set on a TINYINT > > > > 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:[EMAIL PROTECTED]] > > > 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 > <[EMAIL PROTECTED]> > > > To unsubscribe, e-mail > > > <[EMAIL PROTECTED]> > > > Trouble unsubscribing? Try: > http://lists.mysql.com/php/unsubscribe.php > > > > > > > --------------------------------------------------------------------- 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 <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
