gistfile1.sql

-- https://github.com/dimitri/pgloader/blob/master/src/sources/mysql/sql/list-all-columns.sql

-- mysql 5.0
+---------------------+---------------+------------------------+----------------+----------------+---------------------+----------------+-------------+-------+
| table_name          | table_comment | column_name            | column_comment | data_type      | column_type         | column_default | is_nullable | extra |
+---------------------+---------------+------------------------+----------------+----------------+---------------------+----------------+-------------+-------+
| corporate_contracts |               | contract_value         |                | float unsigned | float unsigned      | NULL           | NO          |       |
+---------------------+---------------+------------------------+----------------+----------------+---------------------+----------------+-------------+-------+

-- mysql 5.7
+------------+---------------+-------------+----------------+-----------+----------------+----------------+-------------+-------+
| table_name | table_comment | column_name | column_comment | data_type | column_type    | column_default | is_nullable | extra |
+------------+---------------+-------------+----------------+-----------+----------------+----------------+-------------+-------+
| ufloats    |               | f           |                | float     | float unsigned | NULL           | NO          |       |
+------------+---------------+-------------+----------------+-----------+----------------+----------------+-------------+-------+