How to Reset Autoincrement ID to the previous ID

I just need a logic on how to Reset Autoincremented ID to the previous ID which I deleted recently from database for example I just delete ID=3 from database next time I add data into database ID will be incremented to 4 and it will be showed as 1 2 4 but I dont want 4 I want it to be 3 Im building a small inventory management system using php and sql.

https://stackoverflow.com/questions/66083375/how-to-reset-autoincrement-id-to-the-previous-id February 07, 2021 at 08:24AM