List:General Discussion« Previous MessageNext Message »
From:Karam Chand Date:July 28 2003 7:56pm
Subject:How to know the maxmimum length of data in a perticular column?
View as plain text  
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

I hope I make myself clear.

Thanks in advance.

Karam


__________________________________
Do you Yahoo!?
Yahoo! SiteBuilder - Free, easy-to-use web site design software
http://sitebuilder.yahoo.com
Thread
How to know the maxmimum length of data in a perticular column?Karam Chand28 Jul
  • Re: How to know the maxmimum length of data in a perticular column?Dan Nelson28 Jul
    • fulltext indexing and query speeds?Niels Larsen28 Jul
      • Re: fulltext indexing and query speeds?Sergei Golubchik28 Jul
    • Re: How to know the maxmimum length of data in a perticular column?Karam Chand29 Jul
      • Category System schemaAlex Pilson29 Jul
        • RE: Category System schemaPeter Lovatt29 Jul
Re: fulltext indexing and query speeds?Sergei Golubchik29 Jul
  • Re: fulltext indexing and query speeds?Niels Larsen29 Jul
    • Re: fulltext indexing and query speeds?Sergei Golubchik30 Jul