title: Rename a MySQL table using SQL statement
body: <p>I want to rename an existing table using SQL statement:</p>
  
  <p>I have already tried:</p>
  
  <ol>
  <li><code>mysql_query("RENAME '$renameFolder' TO '$newName'");</code></li>
  <li><code>mysql_query("ALTER TABLE '$renameFolder' RENAME TO '$newName'");</code></li>
  <li><code>mysql_query("RENAME TABLE '$renameFolder' TO '$newName'");</code></li>
  </ol>
  
  <p>Using any of the 3 statements I'm always getting the same error message:</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"</p>
  </blockquote>
  
  <p>Please tell me what I'm doing wrong!</p>