title: Do conditional INSERT with SQL?
body: <p>I have a database that is updated with datasets from time to time. Here it may happen that a dataset is delivered that already exists in database.</p>
  
  <p>Currently I'm first doing a</p>
  
  <pre><code>SELECT FROM ... WHERE val1=... AND val2=...
  </code></pre>
  
  <p>to check, if a dataset with these data already exists (using the data in WHERE-statement). If this does not return any value, I'm doing my INSERT.</p>
  
  <p>But this seems to be a bit complicated for me. So my question: is there some kind of conditional INSERT that adds a new dataset only in case it does not exist?</p>
  
  <p>I'm using <strong><a href="http://www.smallsql.de/">SmallSQL</a></strong></p>