All - I've got a table that has an unsigned int that stores increasing
sequence numbers that are stored in UDP payloads. Occasionally, messages
get lost and we'll have missing numbers in the sequence. These are not
auto_incrementing columns, the sequence numbers are assigned by the
application
I don't think you can get a query which will return a row for each
missing result, because a query can only return data that's there, not
data that's missing. (although if you generated another table with all
the numbers 1 through 1,000,000 that would work).
Anyway, to get one result row per