MySQL rename and overwrite an existing table
<p>In MySQL user manual, it says the following command is way faster than the RENAME command since no table copy is required.</p>

<pre><code>ALTER TABLE table1 RENAME TO table2;
</code></pre>

<p><a href="http://dev.mysql.com/doc/refman/5.7/en/alter-table.html" rel="nofollow">http://dev.mysql.com/doc/refman/5.7/en/alter-table.html</a></p>

<p>However, is there anyway that we can quickly rename/overwrite a table into an existing table in MYSQL 5.6? I have tried the following command and it shows error "You have an error in your SQL synthax;"</p>

<pre><code> ALTER TABLE table1 RENAME OVERWRITE TO table2;
</code></pre>

<p>Could any guru enlighten?  Thanks.</p>