Hello and questions
Date: 08/31/06
(MySQL Communtiy) Keywords: mysql, sql, web
Hello, I just found the MySQL community and figured this could be an educational group to watch. I am predominately a web developer 1st, and a DB scheme designer by necessity. Otherwise I learned SQL on Access in 1999 then it took me 3-4 years to unlearn the MS way and now prefer MySQL. So yeah, that's me.
Now my fun filled question: Is there some sort of way to join 'SHOW TABLES' and 'SHOW FIELDS FROM' in a SQL query? Maybe a multi-line query or such that is dynamic. I've been rummaging through the MySQL reference manual and found nothing so far... though I did try the crazy idea of DESCRIBE (show tables); which was a long shot that did nothing.
Update:
Got this from beskov's comment.
SELECT table_name, column_name
FROM Information_Schema.columns;
And added WHERE to focus just on the DB I am interested in.
SELECT table_name, column_name
FROM Information_Schema.columns
WHERE table_schema = 'myDbName';
Source: http://community.livejournal.com/mysql/102165.html