I would like to know something like this.I have a specific record to delete from a table.When the delete operation is successful,it will delete the row with specific id(Primary key & auto_increment').
Eg.I have a table with 3 rows and These 3 records have id field filled with int data(auto_increment).That is 1,2,3.What I would like to do is when I delete the 2nd row and the 3rd row id will automatically reassigned to the above row id(the deleted row id).The 3rd row id will be 2 and like that.How to do it?Is it possible to make it like that?I need some advice from you all.Thank you very much.
What you are trying to do is recycle key values, and it's generally not advisable to attempt it. You just have to ignore the deleted primary key values. Primary autoincrement keys in database are used to uniquely identify a given row and should be used for just that. Do not apply any business meaning to it.
Bosun (SCJP, SCWCD).
So much trouble in the world -- Bob Marley
No, Bear.I understand and accept.I just want to know whether any sql keyword for this one has or not.No real world reason to do this.It is just my thought of doing this thing.If I want to do 'the key recycle values',I just have to manually do in the database or from the code right?No easy and straight way?Sorry I am just a beginner.
Thank you Bear & Bosun!