Re: How to know the maxmimum length of data in a perticular column?

[Dan Nelson]

In the last episode (Jul 28), Karam Chand said:
> Greetings
> 
> Is there any query to know the maximum string length
> of data in every column of the table?
> 
> For eg, if I have data -
> 
> 1,mysql@stripped,2000-12-12
> 20,me@stripped,NULL
> ...
> 
> It will return me 
> 
> 2,15,10

SELECT MAX(LENGTH(field1)) AS f1len, MAX(LENGTH(field2)) AS f2len,
 MAX(LENGTH(field3)) AS f3len FROM mytable;

-- 
	Dan Nelson
	dnelson@stripped