How to get a list of IDs not present in a (My)SQL table?
<p>I have a MySQL table, that looks like this:</p>

<pre><code>+----+
| id |
+----+
| a  |
| c  |
| e  |
+----+
</code></pre>

<p>I want to check which of the following ids <code>a</code>, <code>b</code>, <code>c</code>, <code>d</code>, <code>e</code> does not exist in the table.</p>

<p>Meaning, I want to get a list of the ids <code>b</code> and <code>d</code> back.</p>

<p>Is there a single query I can construct by hand that returns a list of IDs that does not exist in my table, without actually creating a new second permanent SQL table?</p>