title: Syntax error while creating Materialized View in MySQL
body: <p>Syntax error while creating materialized view in MySQL:</p>
  
  <p>Tried to create the mview as below:</p>
  
  <pre><code> create materialized view test.dept10
   as
   select * from test.employees
   where deptno=10;
  
  **ERROR 1064 (42000):** You have an error in your SQL syntax; check the manual that
  corresponds to your MySQL server version for the right syntax to use near 'materialized view test.dept10
  </code></pre>