title: INSERT INTO SQL DATEADD Yesterday
body: <p>I want to use PHP and MySQL to INSERT the the day of Yesterday. So my idea was:</p>
  
  <pre><code>INTO chartValues SET timestamp='1353369600', `datetime`=DATEADD(d,-1,GETDATE())
  </code></pre>
  
  <p>But its not working:</p>
  
  <blockquote>
    <p>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 'INTO chartValues SET timestamp='1353369600',
    <code>datetime</code>=DATEADD(d,-1,GETDATE())' at line 1</p>
  </blockquote>
  
  <p>Thanks in advance</p>