title: How to update a view in phpMyAdmin?
body: <p>How can I update (or edit) a View in MySQL database using phpMyAdmin.</p>
  
  <p>I got a view that's made of columns from two tables - I added a new column to one of these, but the view doesn't have it. I can't find the MySQL query I used to get this view (it's quite obscure one) - so how can I edit the MySQL query that created this view to add a new column into it?</p>