0

Hello all of you .

I just wana know to return to same id when we delete it from the database

for exmaple when we delete the user_id that equal to 1 the next when we

enter the new record the user_id will became 2 i want to make it one in the

databse record . thats all and thanks in advance ....

6
Contributors
6
Replies
7
Views
8 Years
Discussion Span
Last Post by JRSofty
0

Why do you want to do this?


anyway, if you really, really want to do this, you can do it on insert. when you want to save a new record, first you get the last ID, and when insert the new record, you increment it by 1. also, be sure your column has no auto_increment property.

0

I agree with silviuks that generally, what you want isn't a good idea :-)

I'm not sure if what you are after is to fill blanks in a row of user_ids.
What if you have three users: 1, 2, 3 and delete 2. Do you want the next new user to receive 2 again or 4?
If your answer is 2 then I suggest you forget about it. This really stinks (http://en.wikipedia.org/wiki/Code_smell). Perhaps tell us why on Earth you would want something like this and we help you solve the real problem.

0

he has ids 1 2 3 4
he deletes 2 so now he has 1 3 4
he wants to loop through the ids so that they would become 1 2 3, which I am not sure if this a good or bad idea as would it mess everything up.

0

I would say it is a hiddeous idea honestly. This because what if there are references to the user_id in other tables? Then you would have to go through all these tables and update them to match the new settings. This can cause a lot of needless overhead for your application and your users won't want to sit there waiting for the updates to happen.

I would suggest setting your user_id column to a large enough integer for what you need and then do as forzadraco said and set the column to auto_increment.

This article has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.