mysql一个字段最大长度,确定mysql中的一列中允许的最大长度

The structure of the table is like:

registrant_id varchar(16)

registrant_name varchar(128)

I want to run a query that displays all those entries which match the maximum PERMISSIBLE length, ie what I do currently do for the above:

SELECT *

FROM `tm_registrant`

WHERE length( `registrant_name` ) = 128

However, I dont want to hardcode 128 as I have many columns and want to run one query to see all the entries which have atleast one completely 'filled up' column.

解决方案SELECT CHARACTER_MAXIMUM_LENGTH

FROM INFORMATION_SCHEMA.COLUMNS

WHERE table_name = 'your_table_name'

AND table_schema = 'your_db_name'

AND column_name = 'your_column_name'

LIMIT 0 , 1