- 获取某个数据库里编码分布
SELECT
TABLE_COLLATION,
COUNT( 1 )
FROM
information_schema.TABLES
WHERE
table_schema = 'coin_dgdfhfdg'
GROUP BY
TABLE_COLLATION;
SELECT
TABLE_COLLATION,
COUNT( 1 )
FROM
information_schema.TABLES
WHERE
table_schema = 'coin_dgdfhfdg'
GROUP BY
TABLE_COLLATION;