0

I am create table and made ID field is auto increment When I delete the row, the ID continues after the deleted row id OR How sort ID after remove some rows Example When I delete the row ID 38 and then add a row that stores ID 39 not 38 this mean id is not sort How to block mysql increase when Do that ?

Dharman
  • 30,962
  • 25
  • 85
  • 135
Abdalrazag Al-Shrofat
  • 1
  • 1
  • 4
  • 2
    My opinion is : you do not solve this. It is not a problem ... – VBoka Nov 03 '19 at 17:04
  • 1
    Does this answer your question? [Auto Increment after delete in MySQL](https://stackoverflow.com/questions/2214141/auto-increment-after-delete-in-mysql) – VBoka Nov 03 '19 at 17:07
  • Don't confuse auto incremented ID with a consecutive numbering. IDs do not need to be contiguous. – Dharman Nov 03 '19 at 17:21

0 Answers0