From: Date: August 24 2007 5:27pm
Subject: Re: Column type suggestions
List-Archive: http://lists.mysql.com/mysql/208710
Message-Id: <46CEF8FC.7040307@xaprb.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

Search the manual and the web for PROCEDURE ANALYSE() and some examples 
of how to use it.  (It's not obvious how to get good results).  I think 
Ronald Bradford has a good blog post on it.

Benjamin Wiechman wrote:
> I recall there is a command that will display suggested optimal columns
> types for a given table based on the data stored in the table, but I haven't
> been able to figure out what it is.
> 
>  
> 
> Help!
> 
>  
> 
> Thanks. 
> 
>  
> 
> Ben Wiechman
> 
> Wisper High Speed Internet
> 
> ben@stripped
> 
>  
> 
>