摘要：
SELECT TABLE_SCHEMA, TABLE_NAME, COLUMN_NAME, DATA_TYPE, ( CASE WHEN DATA_TYPE IN ('tinyint') THEN 1 WHEN DATA_TYPE IN ('smallint') THEN 2 WHEN DATA_T 阅读全文
摘要：
SELECT t.TABLE_NAME, -- t.table_type, SUM( CASE WHEN c.DATA_TYPE = 'tinyint' THEN 1 WHEN c.DATA_TYPE = 'smallint' THEN 2 WHEN c.DATA_TYPE = 'mediumint 阅读全文