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. Link to comment https://forums.phpfreaks.com/topic/204060-mysql-row-deleted/ Share on other sites More sharing options...
fenway Posted June 7, 2010 Share Posted June 7, 2010 Say what? Link to comment https://forums.phpfreaks.com/topic/204060-mysql-row-deleted/#findComment-1068927 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. Link to comment https://forums.phpfreaks.com/topic/204060-mysql-row-deleted/#findComment-1074663 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. Link to comment https://forums.phpfreaks.com/topic/204060-mysql-row-deleted/#findComment-1074684 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.