Ian Su wrote: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?I need some advice from you all.Thank you very much.
Love all, trust a few, do wrong to none.
Love all, trust a few, do wrong to none.
Naresh Waswani
Naresh Waswani