Primary key problem

[Anon]

I have 1 table and I deleted couple of rows in it.
Now primary key is sketchy. Its not 1,2,3,4 anymore. Its like 1,4,9 etc. Deleted primary key numbers will never be used again when I insert new data.
How can I update primary key so that every time when I insert or delete data it will be automatically in sequence?

Thank you.
Regards P2tu.

[Anon]

virtually every database out there will not allow you to repeat primary key numbers the idea being that every record (even deleted ones) will have a completely unique number. The only way around it is to manaully index the numbers then dump the schema of the db out to a text file (mysqldump for example) and then reload it.

If you really wanted to anal about it you could set your primary key not to auto increment and write a script that figures out what the next number should be. This would probably have a big performance hit on large tables.

[Anon]

Ok, thank you.