How to get id's that don't exist?

Question

MySQL

There is a table with a field id (INT)
The id field is unique.
We know the range the id's are in.
How to write a query that returns id, rows for which are not in the table?
Example
id
1
2
3
4
5
7
8
9
In the range from 1 to 9, the query should return 6 because there is no such id.

Answer 1

stackoverflow.com/questions/12325132/mysql-get-mis...