title: Rename a table in MySQL
body: <p>Renaming a table is not working in MySQL</p>
  
  <pre><code>RENAME TABLE group TO member;
  </code></pre>
  
  <p>The error message is</p>
  
  <pre class="lang-none prettyprint-override"><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 'group 
          RENAME TO member' at line 1
  </code></pre>
  
  <p>The query is working fine on other tables for me, but not with the table <code>group</code>.</p>