To expand one what CheeseConQueso is saying, here are the entire steps to update a view using PHPMyAdmin:
- Run the following query:
SHOW CREATE VIEW your_view_name
- Expand the options and choose Full Texts
- Press Go
- Copy entire contents of the Create View column.
- Make changes to the query in the editor of your choice
- Run the query directly (without the
CREATE VIEW... syntax) to make sure it runs as you expect it to.
- 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.
- Place a check in the OR REPLACE field.
- In the VIEW name put the name of the view you are going to update.
- In the AS field put the contents of the query that you ran while testing (without the
CREATE VIEW... syntax).
- Press Go
I hope that helps somebody. Special thanks to CheesConQueso for his/her insightful answer.