AutoInc help

[Xalo]

I have a list in mysql that has it's primary key as your standard auto_inc 'id'.

This an example of the list: (id, name)

1 Will Robinson
2 The Robot
3 Dr Smith

This is what happens when I delete a line:

1 Will Robinson
3 Dr Smith

This is what I WANT to happen when I delete a line:

1 Will Robbinson
2 Dr Smith

Is this possible, and if so how do I do it? Thanks

[sfullman]

absolutely not. How would the system know how to collapse over a million records if the table was that large? You'd have a very complex cascade of transactions, and that auto-inc field would have no meaning to anyone else simultaneously using the database. For that reason alone, even if it were possible, it wouldn't be a good idea.

As long as your sort criteria is iron clad (off the autoinc field itself), when doing your while() loop, you can just increment a variable in PHP as $i++, so that records in the db with sequence 1, 4,5,6, 8,9 .. could be referenced as 1,2,3,4,5,6..

Sam

[Xalo]

Alright, alright, no need to get excited, not like the idea was completely propostorous. Thanks for your help all the same though.