MySQL 5.0: Can I retrieve the query used to create a view?
I have several views based on complex queries. From time to time I want to alter these, but re-creating the query is tedious (yes, I know, I should have saved them as a script file on my pc).
Is there a way to retrieve the query? Trying describe view; just shows me columns, datatypes, and so on.