title: Possible to get the code powering a view in MySQL?
body: <p>Well I'm a bit of an idiot, I wrote a view then accidently closed the window so now I don't have a copy of the query powering it.  Syntax was:</p>
  
  <pre><code> CREATE VIEW view_name AS SELECT something FROM somewhere
  </code></pre>
  
  <p>Is there a way to get the "SELECT something FROM somewhere" or am I going to have to rewrite it from memory?</p>