Mysql 查看varchar和char类型表的列长度

1. SELECT table_name, SUM(character_maximum_length) AS sum_length
2. FROM information_schema.columns
3. WHERE table_schema='gscloud2103mysql' and data_type in ('char','varchar')
4. GROUP BY table_name
5. ORDER BY sum_length desc

复制代码

 

免责声明：如果侵犯了您的权益，请联系站长，我们会及时删除侵权内容，谢谢合作！