Auto Increment after delete in MySQL

by

What you’re trying to do sounds dangerous, as that’s not the intended use of AUTO_INCREMENT.

If you really want to find the lowest unused key value, don’t use AUTO_INCREMENT at all, and manage your keys manually. However, this is NOT a recommended practice.

Take a step back and ask “why you need to recycle key values?” Do unsigned INT (or BIGINT) not provide a large enough key space?

Are you really going to have more than 18,446,744,073,709,551,615 unique records over the course of your application’s lifetime?

More Related Contents:

  1. Can you access the auto increment value in MySQL within one statement?
  2. Is there AUTO INCREMENT in SQLite?
  3. INNER JOIN ON vs WHERE clause
  4. How to SELECT the newest four items per category?
  5. Simple way to calculate median with MySQL
  6. How do I make a row generator in MySQL?
  7. MySQL INSERT INTO table VALUES.. vs INSERT INTO table SET
  8. MySQL number of items within “in clause”
  9. Error 1046 No database Selected, how to resolve?
  10. Reset auto increment counter in postgres
  11. What’s the difference between VARCHAR and CHAR?
  12. Alter a MySQL column to be AUTO_INCREMENT
  13. Is there something wrong with joins that don’t use the JOIN keyword in SQL or MySQL?
  14. single fixed table with multiple columns vs flexible abstract tables
  15. MySQL remove duplicates from big database quick
  16. How to delete from select in MySQL?
  17. How to delete Duplicates in MySQL table
  18. Selecting Random Rows in MySQL
  19. SQLite auto-increment non-primary key field
  20. Error: The used SELECT statements have a different number of columns
  21. How to Optimize Queries in a Database – The Basics
  22. Any way to achieve fulltext-like search on InnoDB
  23. Create date from day, month, year fields in MySQL
  24. Can I use a MySQL database with an App Engine application
  25. How to combine aggregate functions in MySQL?
  26. How do I list all the columns in a table?
  27. VARCHAR as foreign key/primary key in database good or bad?
  28. MySQL: Get character-set of database or table or column?
  29. How to get the byte size of resultset in an SQL query?
  30. MySQL subquery returns more than one row

Leave a Comment