[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

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

with mariadb/mysql: 2014-11-05 4:20 GMT-02:00 Ron Piggott : > > 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_

[PHP-DB] ANN: PHP Generator 14.10 released

Hi! SQL Maestro Group announces the release of PHP Generator 14.10, a family of GUI frontends for Windows that allow you to generate feature-rich CRUD web applications for your databases. There are versions for MySQL, MS SQL Server, PostgreSQL, Oracle, SQLite, Firebird, DB2, SQL Anywhere and M

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