title: MySQL "WITH" clause
body: <p>I'm trying to use MySQL to create a view with the "WITH" clause</p>
  
  <pre><code>WITH authorRating(aname, rating) AS
     SELECT aname, AVG(quantity)
     FROM book
     GROUP BY aname
  </code></pre>
  
  <p>But it doesn't seem like MySQL supports this.</p>
  
  <p>I thought this was pretty standard and I'm sure Oracle supports this. Is there anyway to force MySQL to use the "WITH" clause?  I've tried it with the MyISAM and innoDB engine.  Both of these don't work.</p>