[pk_jsp]

Hi all
Is there a way to set the autonumber field of a table .I mean I if a table contains 20 records and a new record gets 21 as autonum field.
If I delete first 10 records isit possible that it adjusts itself so that new records start form 11 instead of 21

Prashant Dubey

[mdhall]

If you are talking about the auto-increment, no. Each new row added gets the next id number counting upward. So if you have 21 rows, then delete the first 10, the next row will still get the number 22. Mysql doesnt go back to fill the open id numbers, as far as I know.