From: Date: August 24 2007 6:20pm
Subject: RE: Column type suggestions
List-Archive: http://lists.mysql.com/mysql/208713
Message-Id: <0EFC73B4AC46D411BC6900B0D020B7BE10F9C49C@amcmail.touchgroupplc.com>
MIME-Version: 1.0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

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:benw@stripped]
Sent: 24 August 2007 16:18
To: mysql@stripped
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.

=20

Help!

=20

Thanks.=20

=20

Ben Wiechman

Wisper High Speed Internet

ben@stripped

=20


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 postmaster@stripped. 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