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 '[info]'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

« Can't connect || Freeware search »


antivirus | apache | asp | blogging | browser | bugtracking | cms | crm | css | database | ebay | ecommerce | google | hosting | html | java | jsp | linux | microsoft | mysql | offshore | offshoring | oscommerce | php | postgresql | programming | rss | security | seo | shopping | software | spam | spyware | sql | technology | templates | tracker | virus | web | xml | yahoo | home