ToB企服应用市场:ToB评测及商务社交产业平台

标题: Mysql 查看varchar和char类型表的列长度 [打印本页]

---

作者: 道家人    时间: 2022-8-11 00:02
标题: 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

复制代码

 

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

---

欢迎光临 ToB企服应用市场:ToB评测及商务社交产业平台 (https://dis.qidao123.com/)

Powered by Discuz! X3.4