title: MySQL error when inserting data containing apostrophes (single quotes)?
body: <p>When I an insert query contains a quote (e.g. <code>Kellog's</code>), it fails to insert a record.</p>
  
  <p>ERROR MSG:</p>
  
  <blockquote>
    <p>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 's','Corn Flakes 170g','$ 15.90','$ 15.90','$ 14.10','--')' at
    line 1MySQL Update Error:</p>
  </blockquote>
  
  <p>The first <code>'s'</code>, should be <code>Kellogg's</code>.</p>
  
  <p>Is there any solution?</p>