But if I have varchar fields won't the size of the record vary based on the actual contents in the varchar fields.
Arun --- Paul DuBois <[EMAIL PROTECTED]> wrote: > At 18:38 -0800 12/27/02, Arun Kumar wrote: > >Dear All, > > I have a table 'X', I want to display the record > > in this table 'X' which has occupied the maximum > > number of bytes, i.e i want a query/queries to > >display the record with maximum size. I would also > >like to print the > > record size as well. > > > > Any help in this front would be great. > > Arun > > You'll have to calculate record size yourself based > on knowledge > about the types of the columns in the table and the > storage occupied > by those types. __________________________________________________ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.com --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php