MySQL get missing IDs from table

by 
SELECT a.id+1 AS start, MIN(b.id) - 1 AS end
    FROM testtable AS a, testtable AS b
    WHERE a.id < b.id
    GROUP BY a.id
    HAVING start < MIN(b.id)

Hope this link also helps
http://www.codediesel.com/mysql/sequence-gaps-in-mysql/

More Related Contents:

  1. How do you use MYSQL in ColdFusion? [closed]
  2. Using LIMIT within GROUP BY to get N results per group?
  3. Using backticks around field names
  4. How do I do a bulk insert in mySQL using node.js
  5. Reorder / reset auto increment primary key
  6. Required to join 2 tables with their FKs in a 3rd table
  7. Save Data in Arabic in MySQL database
  8. Setting the MySQL root user password on OS X
  9. How to change the CHARACTER SET (and COLLATION) throughout a database?
  10. Mysql::Error: Specified key was too long; max key length is 1000 bytes
  11. GROUP_CONCAT with limit
  12. How can I get around MySQL Errcode 13 with SELECT INTO OUTFILE?
  13. SQL Query to show nearest date?
  14. How can I modify the size of column in a MySQL table?
  15. How to auto generate migrations with Sequelize CLI from Sequelize models?
  16. Getting all parent rows in one SQL query
  17. How can I manipulate MySQL fulltext search relevance to make one field more ‘valuable’ than another?
  18. Creating functions in phpMyAdmin – Error: access denied you need the super privilege for this operation
  19. How to connect to MySQL from the command line
  20. MySQL – Recursing a tree structure
  21. Remove DEFINER clause from MySQL Dumps
  22. How to retrieve JSON data from MySQL?
  23. Is incrementing a field in MySQL atomic?
  24. Delete from one table with join
  25. MySQL column type “TIMESTAMP” implicitly includes “NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP”
  26. Encryption at rest and/or AES_ENCRYPT
  27. MySQL: Compare BETWEEN time
  28. How to import large sql file in phpmyadmin
  29. How to figure out size of Indexes in MySQL
  30. Failed to connect to mysql at 127.0.0.1:3306 with user root access denied for user ‘root’@’localhost'(using password:YES)

Leave a Comment