How To Reseed deleted Records

[vinoindiamca]

Hi,

  I had a doubt in reseeding deleted values

For example if records stored like

S.No  Name    Contact

1      aaa    5656656

2      bbb    5656656

3      ccc    5656656

4      ddd    5656656

 

if i used to delete one record of second record it looks

 

S.No  Name    Contact

1      aaa    5656656

3      ccc    5656656

4      ddd    5656656

 

i need the result to be reseed values like

 

1      aaa    5656656

2      ccc    5656656

3      ddd    5656656

 

Please help in this

 

 

 

[shlumph]

Why would you want to do this? Many novices wish to do this, but they don't need to.

[omfgthezerg]

UPDATE TABLE `table` SET AUTO_INCREMENT = 3

[aschk]

I believe omfgthezerg's solution may be wrong, as you do NOT want to set the auto_increment back to 3. This will cause key conflicts on keys that exist that are higher than this value.

 

As shlumph posted "why do you want to do this?". You probably don't need to.

[shlumph]

As shlumph posted "why do you want to do this?". You probably don't need to.

 

Especially if your database grows. What if you want to link this table to other tables? You'll have to update all those tables too! Is there a specific reason why you want no gaps in numbers? We can probably find a better solution...

[JonnoTheDev]

There is no reason for you to do this.