row deleting problem - primary key help
Posted: Tue Feb 15, 2005 10:11 am
I asked here about deleting a row, thanks to u people i found it easy.
But know i have a new problem. my table has an "id"-primary key and autoincrement, when I delete lets say row number 2, the next id after 1 becomes 3.
1- server a-on
2- server b-on <--- delete
3- server c-on
=> 1-server a-on
3-server c-on <----- i want this one to be 2-server c-on
4-server d-on <----- and this one to become 3-server d-on
But know i have a new problem. my table has an "id"-primary key and autoincrement, when I delete lets say row number 2, the next id after 1 becomes 3.
1- server a-on
2- server b-on <--- delete
3- server c-on
=> 1-server a-on
3-server c-on <----- i want this one to be 2-server c-on
4-server d-on <----- and this one to become 3-server d-on