From: Dan Nelson
Date: July 28 2003 8:08pm
Subject: Re: How to know the maxmimum length of data in a perticular column?
List-Archive: http://lists.mysql.com/mysql/146322
Message-Id: <20030728200816.GB3058@dan.emsphone.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii

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