+-----------------+-----------+ | data_type | frequency | +-----------------+-----------+ | blob | 7 | | char | 611 | | date | 85 | | datetime | 125 | | decimal | 133 | | double unsigned | 1 | | enum | 677 | | float | 5 | | int | 2334 | | mediumblob | 21 | | mediumint | 3 | | set | 9 | | smallint | 7 | | text | 57 | | time | 551 | | timestamp | 20 | | tinyint | 6 | | varchar | 946 | +-----------------+-----------+ 18 rows in set (10.36 sec) +---------------+---------------------+-------+ | table_schema | table_name | count | +---------------+---------------------+-------+ | database_1 | object_payment | 14 | | database_2 | object_payment | 12 | | database_3 | object_payment | 11 | | database_2 | object_space | 9 | | database_1 | object_space | 9 | | database_1 | aggregation_table_1 | 8 | | database_2 | aggregation_table_1 | 8 | | database_2 | aggregation_table_3 | 7 | | database_1 | aggregation_table_4 | 7 | | database_1 | object_user | 7 | +---------------+---------------------+-------+ 10 rows in set (4.91 sec)