title: CREATE TABLE as SELECT - using MEMORY ENGINE (in RAM memory)
body: <p>I was reading about tables using <a href="http://dev.mysql.com/doc/refman/5.5/en/memory-storage-engine.html"><code>MEMORY ENGINE</code></a> (tables stored in ram).</p>
  
  <ul>
  <li><p>Is it possible to use <code>CREATE TABLE AS SELECT</code> syntax, but have the created table us <code>MEMORY ENGINE</code>?</p></li>
  <li><p>Is there a limit to the size of a MEMORY table? Could create a MEMORY table that is a copy of a pysical 1.5 GB table?</p></li>
  </ul>