Re: [PHP-DB] 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 <[email protected] 
> <mailto:[email protected]>>:
>
>
>     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