At 2:40 -0800 12/28/02, Arun Kumar wrote:
But if I have varchar fields won't the size of the
record vary based on the actual contents in the
varchar fields.
Arun
Of course. My answer remains the same. Perhaps I should
add that what all this means is that you must perform
the calculations on a
On Saturday 28 December 2002 12:40, Arun Kumar wrote:
> But if I have varchar fields won't the size of the
> record vary based on the actual contents in the
> varchar fields.
Use LENGTH() function:
http://www.mysql.com/doc/en/String_functions.html
and plus one byte.
--
For technical
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
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
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
