How to copy MySQL table structure to table in memory? <p>How to create a table in memory which is identical to "regular" table? I want a copy without indexes and constraints. Pure SQL (no external tools).</p> <p>This works (however indexes are created):</p> <pre><code>create table t_copy (like t_original) </code></pre> <p>This doesn't:</p> <pre><code>create table t_copy (like t_original) engine=memory </code></pre>