title: Rename table with spaces mysql
body: <p>I have a table 'A B C' (with spaces, don't ask me why) in MySQL database. 
  I have to rename it to 'ABC' 
  This query doesn't work :(</p>
  
  <pre><code>rename table 'A B C' to 'ABC'
  </code></pre>
  
  <p>What should be the correct query?</p>
  
  <p>I get the same usual error </p>
  
  <pre><code>'You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version'
  </code></pre>