Jump to content

mysql row deleted


jmr3460

Recommended Posts

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

  • 2 weeks later...

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

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.