jmr3460 Posted June 7, 2010 Share Posted June 7, 2010 Is there a way to direct mysql to not use rows that were deleted? I have a calendar database that has rows deleted, sometimes 1 row, sometimes 3 rows. When I insert new rows of data mysql uses some of those deleted rows to insert new data on. Can I stop this from happening? This could cause problems when I find duplicates and delete them. Quote Link to comment Share on other sites More sharing options...
fenway Posted June 7, 2010 Share Posted June 7, 2010 Say what? Quote Link to comment Share on other sites More sharing options...
jmr3460 Posted June 20, 2010 Author Share Posted June 20, 2010 When I delete a row of information the row number sometimes is used again. Say I delete the information on row 5. If the total number of rows say is 15 less the row number 5 sometimes when I insert new information mysql will use row 5 again. Quote Link to comment Share on other sites More sharing options...
fenway Posted June 20, 2010 Share Posted June 20, 2010 When I delete a row of information the row number sometimes is used again. Say I delete the information on row 5. If the total number of rows say is 15 less the row number 5 sometimes when I insert new information mysql will use row 5 again. When you say "row number", do you mean the auto-increment column? It won't get re-used unless you truncated the table. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.