mysql - How can I edit a view using phpMyAdmin 3.2.4?

Question

I need to simply edit a very complicated view in phpMyAdmin 3.2.4 but I cannot figure how to do that. Any suggestions? Thanks!

Answer 1

To expand one what CheeseConQueso is saying, here are the entire steps to update a view using PHPMyAdmin:

1. Run the following query: SHOW CREATE VIEW your_view_name
2. Expand the options and choose Full Texts
3. Press Go
4. Copy entire contents of the Create View column.
5. Make changes to the query in the editor of your choice
6. Run the query directly (without the CREATE VIEW... syntax) to make sure it runs as you expect it to.
7. Once you're satisfied, click on your view in the list on the left to browse its data and then scroll all the way to the bottom where you'll see a CREATE VIEW link. Click that.
8. Place a check in the OR REPLACE field.
9. In the VIEW name put the name of the view you are going to update.
10. In the AS field put the contents of the query that you ran while testing (without the CREATE VIEW... syntax).
11. Press Go

I hope that helps somebody. Special thanks to CheesConQueso for his/her insightful answer.