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
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
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