title: what is the difference between 'alter table rename' and 'rename table'?
body: <p>I am using MySQL. Here's an example, I want to rename a table A to B, so what's the difference between following statement:</p>
  
  <pre><code>alter table A rename to B;
  </code></pre>
  
  <p>and this one:</p>
  
  <pre><code>rename table A to B;
  </code></pre>
  
  <p>Can anyone give a detail compare between them? Is it vary based on different engine?</p>