Update or otherwise create an entry in table
<p>I want to update or create a new entry in a table with normal SQL (not MySQL).
My table has columns: T_ID, ITERATION, COMMENT</p>

<p>I know that I can update my table with:</p>

<pre><code>UPDATE TABLE
    SET ITERATION = ITERATION + 1
    WHERE T_ID = 1;
</code></pre>

<p>But if no entry with T_ID = 1 exists I want to create an entry with ITERATION = 1 and T_ID = 1 and as COMMENT nothing.</p>

<p>Is this possible by using a normal SQL statement?</p>