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
