xtiano77
03-25-2009, 02:06 AM
I am new to MySQL, so forgive me if this question sounds too simple for those with more experience than me. Here it goes...
I have a table named "familypictures" which holds 30 rows. Now, after deleting a row and adding another one later, I noticed that the primary key, which is set to "auto_increment", doesn't take the next number after the last row. What I mean is that if I had 30 rows and deleted one, bringing me back to 29, and then add another row, the new row's primary key value will now have a value of 31. Shouldn't that row be renumbered back to 30?
I have a table named "familypictures" which holds 30 rows. Now, after deleting a row and adding another one later, I noticed that the primary key, which is set to "auto_increment", doesn't take the next number after the last row. What I mean is that if I had 30 rows and deleted one, bringing me back to 29, and then add another row, the new row's primary key value will now have a value of 31. Shouldn't that row be renumbered back to 30?