Add a "Save As" button to Views

[expired user #7856]'s profile image [expired user #7856] posted 10 years ago in Feature discussion Permalink
When there is no easy way to clone or duplicate a View?
- Solution would be to add a "Save As" button to Views
- That way I could make quick changes to the SQL and quickly "Save As" a new version of the View..

As it is, you have to copy & paste.
ansgar's profile image ansgar posted 10 years ago Permalink
There is a "Create" > "Table copy" menu item, but I never thought about copying other types than a table. Copy + paste is not the badest solution, but theat does not only apply to views, but also for procedures, triggers and events.
[expired user #7856]'s profile image [expired user #7856] posted 10 years ago Permalink
What happens to me quite often is that I open up a View, try a few what-if's in SQL, and then can't get back to the original because you're forced to Save your changes in order to run it..

The "Save As" option makes the most sense so not to upset the original View..
alfiqmiq's profile image alfiqmiq posted 10 years ago Permalink
Because MySQL stores the views converted to its own format, I think a better solution is to write a SQL query in a separate file which is more readable for further modification.

Please login to leave a reply, or register at first.