How can I edit a view using phpMyAdmin 3.2.4?

Viewed 136726

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!

5 Answers

try running SHOW CREATE VIEW my_view_name in the sql portion of phpmyadmin and you will have a better idea of what is inside the view

Select your view in Bookmarked SQL query section then select Delete then click Go button.

Related