[PHP-DB] MariaDB Database / Table Structure
Hi Everyone. I am wondering if there are database queries that would a: produce the result of all the tables with a database * b: produce the result of all the columns with the specified database table * * 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
Re: [PHP-DB] MariaDB Database / Table Structure
with mariadb/mysql: 2014-11-05 4:20 GMT-02:00 Ron Piggott ron.pigg...@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
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 ron.pigg...@actsministries.org mailto:ron.pigg...@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