Webmaster Forum

Go Back   Webmaster Forum > Web Development > Web Design Lobby

Web Design Lobby Forum for general web design issues not specific to scripting or graphics.


 
 
LinkBack Thread Tools Display Modes
Prev Previous Post   Next Post Next
Old 12-14-2008, 03:40 PM   #1 (permalink)
Contributing Member
 
Join Date: 12-14-08
Posts: 140
iTrader: 0 / 0%
Latest Blog:
None

2939195631902 is liked by many
Unhappy auto_increment unable to recognize deleted rows in MYSQL

I've been messing with mysql for the past 3 hours and came to realize that the auto_increment is unable to recognize deleted rows.

What i mean is when i delete a row with id of 4, and then add another row, the auto_increment will give the new row a id of 5 instead of 4.

The end result will be 4 rows with ids: 1, 2, 3, 5 instead 1, 2, 3, 4.

Is there a way to fix this?

If not, is there a benefit to the auto_increment increments.
2939195631902 is offline  
Add Post to del.icio.us
Reply With Quote
Go Back   Webmaster Forum > Web Development > Web Design Lobby

 


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to retrieve the total number of rows when using LIMIT X, XXX yangyang Coding Forum 3 09-21-2008 07:27 PM
MySQL Auto_increment Capo64 Coding Forum 5 12-17-2007 04:15 PM
Does Google recognize js links? GemFashion Google Forum 4 01-29-2006 01:09 PM
Recognize this? South Graphic Design Forum 9 11-11-2003 05:41 PM


Sponsor Links
Get exposure! Contextual Links V7N SEO Blog V7N Directory


All times are GMT -7. The time now is 09:15 PM.
© Copyright 2008 V7 Inc
Powered by vBulletin
Copyright © 2000-2009 Jelsoft Enterprises Limited.


Search Engine Optimization by vBSEO 3.3.0 ©2009, Crawlability, Inc.