Add a "Save As" button to Views

jlig posted 1 year ago in Feature discussion
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 posted 1 year ago
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.
jlig posted 1 year ago
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 posted 1 year ago
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.