title: is it possible to create a view from another view?
body: <p>It's probably a silly question but it is straight forward.</p>
  
  <p>Is it possible to create a view from an existing view?</p>
  
  <p>Let's say I've tableA. I create vwtableA from tableA and now I want to create vvVwtableA from vwtableA.</p>
  
  <p>In pseudo-code it would be something like:</p>
  
  <pre><code>create view vwA as select * from tableA;
  create view vwvwA as select * from vwA;
  </code></pre>
  
  <p>is this possible?
  I'm trying something like this and I get no MySQL errors executing the statment but I can't browse the second view... MySQL Workbench keeps loading for ever and I don't know if this may be the cause.</p>
  
  <p>My tableA has around 100 000 records, vwA has around 50 000 records and vwvwA should have around 50 000 as well.</p>