Below Mysql query is very useful to Get list of column name from table with its datatype.
You can get list of all the tables name and all the fields count with help of this query.
PHP Mysql Query
In below query just change <–YoursDatabaseName–> to your database and <–YoursTableName–> to your table name where you just want Field values of DESCRIBE statement
//Get total number of TABLES IN a DATABASE
SELECT COUNT(*) AS totalTables