title: SQL - IF EXISTS UPDATE ELSE INSERT Syntax Error
body: <p>I have the following SQL query:</p>
  
  <pre><code>IF EXISTS(SELECT * FROM component_psar WHERE tbl_id = '2' AND row_nr = '1') 
     UPDATE component_psar
        SET col_1 = '1', col_2 = '1', col_3 = '1', col_4 = '1', col_5 = '1',
                   col_6 = '1', unit = '1', add_info = '1', fsar_lock = '1' 
      WHERE tbl_id = '2' AND row_nr = '1' 
  ELSE 
      INSERT INTO component_psar (tbl_id, row_nr, col_1, col_2, col_3, col_4,
                                  col_5, col_6, unit, add_info, fsar_lock)
      VALUES ('2', '1', '1', '1', '1', '1', '1', '1', '1', '1', 'N')
  </code></pre>
  
  <p>Ignore the fact that I'm trying to set every column to '1'. It's just example data. :)</p>
  
  <p>Anyways, executing this query returns a syntax error:</p>
  
  <pre><code>#1064 - You have an error in your SQL syntax; check the manual that corresponds to your
       MySQL server version for the right syntax to use near 'IF EXISTS(SELECT * FROM
       component_psar WHERE tbl_id = '2' AND row_nr = '1') UP' at line 1
  </code></pre>
  
  <p>I've been staring at it and searching the internet for a good half an hour and just can't find this supposed syntax error. It's probably going to end up being something really dumb that I'm missing but I could use you guys' help on this one.</p>