Tell me more ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.
up vote 0 down vote favorite

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.

share|improve this question
1  
Do you know any SQL? – Phil Feb 15 at 1:45

Know someone who can answer? Share a link to this question via email, Google+, Twitter, or Facebook.

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.