gaps

gaps

Finding Missing Values In A MySQL Table

Friday, September 19, 2008 - 09:42

If you have a table of incremental values it can be hard to find out which ones are missing. The only solution might be to write a script to get all the data from the database and see which ones are missing. However, there is a way of doing this without using a script.

Using a standard select query like this:

Category: