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