title: How to implement Materialized View with MySQL?
body: <p>How to implement Materialized Views?</p>
  
  <p>If not, how can I implement Materialized View with MySQL?</p>
  
  <p><strong>Update:</strong></p>
  
  <p>Would the following work? This doesn't occur in a transaction, is that a problem?</p>
  
  <pre><code>DROP TABLE IF EXISTS `myDatabase`.`myMaterializedView`;
  CREATE TABLE `myDatabase`.`myMaterializedView` SELECT * from `myDatabase`.`myRegularView`;
  </code></pre>