Change the id column to something larger than a TINYINT (like MEDIUMINT or
INT). You should also make ID the primary key.
> Hello everyone,
>
> I have a database of alumni at school. Each alumnus that
> registers gets assigned their own id. Id's are made with mysql's
> auto_increment. Everything worked fine until a few days ago when
> everybody that signed up got the id of 127 assigned to them.
> MySQL will NOT assign them an id higher than 127. So, now
> everybody that signs up gets the id of 127. I tried to fix this
> by using update on the table...here is an example of the table:
>
> ID | fname | lname
> ---------------------------
> 127 | MaryBeth | Elliott
> ---------------------------
> 127 | Becky | Beving
> ---------------------------
> 127 | Russell | Oswalt
> ---------------------------
> 127 | Wanda | Oswalt
> ---------------------------
> 127 | Brandon | Kohlwes
> ---------------------------
> 127 | Kenneth | Smith, Jr.
> ---------------------------
> 127 | Benjamin | Dykstra
> ---------------------------
> 127 | Laura | Hand
> ---------------------------
> 126 | Eric | Beal
> ---------------------------
> 125 | Doug | Franklin
> ---------------------------
>
> Here is what I used to try to UPDATE the id:
> UPDATE alumni SET id=128 WHERE fname='Benjamin' AND lname='Dykstra';
> That didn't work, it said that 0 lines were changed and there was
> one warning (couldn't figure out how to read the warning).
>
> I also tried this:
> UPDATE alumni SET id=id+1 WHERE fname='Benjamin' AND lname='Dykstra';
> That also didn't work...same result as above.
>
> I am convinced that my syntax is correct because phpMyAdmin can't
> even change the id. Anybody have any ideas why this happened?
> BTW, I'm running mysql-3.23.38 on NT4.
---------------------------------------------------------------------
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
