Re: Column type suggestions

2007-08-24 Thread Baron Schwartz 
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

[EMAIL PROTECTED]

 






--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: Column type suggestions

2007-08-24 Thread Rhys Campbell 
SELECT * FROM tablename PROCEDURE ANALYSE()

Anyone know of a way to get the size of a row in bytes?


-Original Message-
From: Benjamin Wiechman [mailto:[EMAIL PROTECTED]
Sent: 24 August 2007 16:18
To: mysql@lists.mysql.com
Subject: Column type suggestions


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

[EMAIL PROTECTED]

 


This email is confidential and may also be privileged. If you are not the 
intended recipient please notify us immediately by telephoning +44 (0)20 7452 
5300 or email [EMAIL PROTECTED] You should not copy it or use it for any 
purpose nor disclose its contents to any other person. Touch Local cannot 
accept liability for statements made which are clearly the sender's own and are 
not made on behalf of the firm.

Touch Local Limited
Registered Number: 2885607
VAT Number: GB896112114
Cardinal Tower, 12 Farringdon Road, London EC1M 3NN
+44 (0)20 7452 5300


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]