title: Error creating MySQL view in phpMyAdmin
body: <p>I'm having a hard time trying to create a view in phpMyAdmin. I have a database named <code>myDB</code> and a table named <code>myTable</code>.</p>
  
  <p>In phpMyAdmin I click on the SQL tab, type in :</p>
  
  <pre><code>SHOW CREATE VIEW myView;
  </code></pre>
  
  <p>I got this error <code>MySQL</code> said:</p>
  
  <pre><code>#1146 - Table 'myTable.myView' doesn't exist
  </code></pre>
  
  <p>I don't understand this error message at all, of course it doesn't exist, otherwise why would I want to create it in the first place? And why wouldn't <code>mySQL</code> allow me to create it? How do I create a view?</p>
  
  <p>Thanks</p>