Maximum size of a Mysql column

Question

Good afternoon, folks! I have a question...

I want to get the maximum size of each column of a table, so I’m using

SELECT MAX(LENGTH(nome_coluna_1)), MAX(LENGTH(nome_coluna_2)).... FROM nome_tabela;

The problem is that some columns come with the correct value of their size and others come with the size of the record (then 0)... What can cause this?

Note:It is a table with 120 columns and all are VARCHAR

I accept new suggestions in place of MAX(LENGTH()) haha

Answer 1

It’s like the Kaduamaral said, you can do this consultation:

SELECT character_maximum_length 
FROM   information_schema.columns 
WHERE  table_name = 'nome_tabela'