I have a problem with my database view that is answered in another post. The answer shows the following solution:
mysql -uusername -ppassword -A --skip-column-names -e" SELECT CONCAT('SHOW CREATE VIEW ',table_schema,'.',table_name,'\\G') FROM information_schema.tables WHERE engine IS NULL " | mysql -uusername -ppassword -A --skip-column-names > AllMyViews.sql
How do I translate this so that it can be used in the MySQL interface called PHP Myadmin? I have no access to or knowledge of a command line interface.