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,[EMAIL PROTECTED],2000-12-12
> 20,[EMAIL PROTECTED],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
[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
