Mysql 查看varchar和char类型表的列长度
SELECT table_name, SUM(character_maximum_length) AS sum_lengthFROM information_schema.columns
WHERE table_schema='gscloud2103mysql' and data_type in ('char','varchar')
GROUP BY table_name
ORDER BY sum_length desc
免责声明:如果侵犯了您的权益,请联系站长,我们会及时删除侵权内容,谢谢合作!
页:
[1]