List:General Discussion« Previous MessageNext Message »
From:Rhys Campbell Date:August 24 2007 4:20pm
Subject:RE: Column type suggestions
View as plain text  
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.

 

Help!

 

Thanks. 

 

Ben Wiechman

Wisper High Speed Internet

ben@stripped

 


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

Thread
Column type suggestionsBenjamin Wiechman24 Aug
  • Re: Column type suggestionsBaron Schwartz24 Aug
RE: Column type suggestionsRhys Campbell24 Aug
  • thread_concurrency in linuxAndrew Braithwaite24 Aug
    • thread_concurrency in linuxAndrew Braithwaite31 Aug
      • Re: thread_concurrency in linuxJay Pipes3 Sep
  • thread_concurrency in linuxAndrew Braithwaite29 Aug
    • Re: thread_concurrency in linuxAlex Arul Lurthu29 Aug
      • RE: thread_concurrency in linuxAndrew Braithwaite29 Aug