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

[Karam Chand]

Great.

That does it. Thanks. Thanks. Thanks.

Karam

--- Dan Nelson <dnelson@stripped> wrote:
> 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


__________________________________
Do you Yahoo!?
Yahoo! SiteBuilder - Free, easy-to-use web site design software
http://sitebuilder.yahoo.com