Re: [PHP-DB] MariaDB Database / Table Structure

2014-11-04 Thread Roberto Spadim
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

2014-11-04 Thread Ron Piggott


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