Long story short - I have a column in a table that has type INT and auto increments with each record that is added, it is also the primary key.
If I deleted a record how would I go about changing the other records with an INT that is higher than it to one less? ie. take away one from all the INTs higher up the table.
I am cycling through these records in one instance with a "record + 1" piece of code and say I delete record 5 and I'm on record 4 it will produce an error as the next record is 6.


LinkBack URL
About LinkBacks
Reply With Quote
.
.



and the fact it took until version 5! In short i think very little of mysql 5, and don't get its hudge popularity.
