newbie question ... I have a MySQL table where I want to update
(renumber) the primary numeric key field.
- I successfully turned field off as a primary key index and UN auto
- then created new sequential numbers for it
- then turned back on primary key index and re added auto increment in
BUT when I make a new record it does NOT start where new numbers stop
last is 51
next should be 52
but jumps to 157
Q: is there a way to reset the NEXT SERIAL ID NUMBER somewhere? how
do I fix this?
Thanks - RevDave
Cool @ hosting4days . com