This post can be ignored now. Turned out the datatype for the id field was set to
tinyint, changed it to int and everything worked great.
Tyler
On Thu, 31 May 2001 00:26:12 -0500
Tyler Longren <[EMAIL PROTECTED]> wrote:
> 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.
>
> Thanks everyone,
> --
> Tyler Longren
> [EMAIL PROTECTED]
> Currently Unemployed
> www.noworkfortyler.com
>
>
> ---------------------------------------------------------------------
> 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
