Re: MariaDB Database / Table Structure

This is extremely helpful. Thank you very much. SELECT * FROM information_schema.COLUMNS WHERE TABLE_SCHEMA="'.$val.'" * where $val is a database On Wednesday November 5 2014 2:14 AM, Roberto Spadim wrote:

with mariadb/mysql: 2014-11-05 4:20 GMT-02:00 Ron Piggott <ron.piggott@actsministries.org <mailto:ron.piggott@actsministries.org>>:

    Hi Everyone.

    I am wondering if there are database queries that would

SHOW DATABASES; <- return all databases

    a: produce the result of all the tables with a database *

SHOW TABLES FROM database_name; or USE database_name; SHOW TABLES; or use infomration schema: *SELECT * FROM information_schema.TABLES* or *SELECT TABLE_SCHEMA,TABLE_NAME FROM information_schema.TABLES* or *SELECT DISTINCT TABLE_SCHEMA,TABLE_NAME FROM information_schema.COLUMNS* * *

    b: produce the result of all the columns with the specified
    database table *

SELECT * FROM database_name.table_name LIMIT 0? (and fetch fields names via php functions of result set) or SHOW FIELDS FROM database_name.table_name; or *SELECT * FROM information_schema.COLUMNS WHERE TABLE_SCHEMA="database_name" AND TABLE_NAME="table_name"; (and interact as a result set)*

    * I don't want any other details than these names.

    I am trying to build a WHILE loop that in pseudo code will look
    roughly like

    - query to get a list of all the tables within a database
    - start of a foreach loop (going one table at a time

       - query to get all the column names within the table
       - start of a foreach loop to display column names
       - display column name
       - end of foreach loop

    -end of foreach loop

    Ron

this sounds like a table structure dump to execute a diff, i'm right? -- Roberto Spadim SPAEmpresarial Eng. Automação e Controle