Can I get back default values for column names in a MySQL table?

I can get the column names for a table but is there a way to retrieve the default data value for each column?Here is what I'm using to get the tables column names:\[code\]$q = $dbh->query("DESCRIBE tablename"); $table_fields = $q->fetchAll(PDO::FETCH_COLUMN);print_r($table_fields);\[/code\]This prints an array of column names, but I'm trying to get the default data value for each column name also.
 
Top