On Wednesday 28 July 2004 18:41, Carl Youngblood wrote: > MySQL has an internal counter variable for every table that never gets > decremented. It does not take the highest existing ID. AFAIK it > hasn't done this for years. Are you positive? If you create a record with an autoid field, and it gets a value of 20, then delete that record, then create another one, you're sure it won't get a value of 20? Sean O'Dell