Possible to get the code powering a view in MySQL? -

Well, I'm a stupid, I have written that the scene has been closed by a scene again, so now I have Do not have a copy of the query. It was a syntax:

  Create visual view _New select something from somewhere  

"Select something from somewhere" Is there a way to get it or do I have to write it in memory?

Try this:

  show view view_name;