In SQL, View performs the notable role by storing complicated SQL query into a virtual table. In other words, SQL View is stored/saved SQL query. Many users scrabbled while updating/editing the view. Reason is simple, there is no single click option available on screen to do so.
To change or modify the view, follow the below steps.
Method A: For phpMyAdmin (ver 4.x +)
- Click on Views > Structure of respective table
- Click on Edit view
- Now edit the View query as you wish
Hope, it will helpful to you to edit view in phpMyAdmin. Last but not least, thanks to Mr John Horton who is given idea about this for new version of phpMyAdmin.
Method B: For old phpMyAdmin (ver < 3.x)
- Open phpMyAdmin (i.e. from cPanel > Databases)
- Select Database
- Click on SQL Tab (see below screenshot)
- Type SHOW CREATE VIEW view_name
In this way, you can update/edit your MySQL view in phpMyAdmin. If you know/found any other solution then please share via comments. It would be helpful to the new pathfinder.