In the table Properties... What is Row_Format???

2001-09-07 Thread Pablo Fraga

What´s the diference between The row storage format (Fixed, Dynamic, or
Compressed) .

I'am experiencing problems with update statements which goes against a table
with the row_format property set to Fixed.

Thanks.

Pablo Fraga (MIS).
e-mail: [EMAIL PROTECTED] - [EMAIL PROTECTED]
icq: 113466029



-
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




In the table Properties... What is Row_Format???

2001-09-07 Thread Pablo Fraga

 What´s the diference between The row storage format (Fixed, Dynamic, or
Compressed) .

I'am experiencing problems with update statements which goes against a table
with the row_format property set to Fixed.

Thanks.

Pablo Fraga (MIS).
e-mail: [EMAIL PROTECTED] - [EMAIL PROTECTED]
icq: 113466029




-
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




Re: In the table Properties... What is Row_Format???

2001-09-07 Thread Ed Carp

Pablo Fraga ([EMAIL PROTECTED]) writes:

 What´s the diference between The row storage format (Fixed, Dynamic, or
 Compressed) .

RTFM!

http://www.mysql.com/doc/C/R/CREATE_TABLE.html
http://www.mysql.com/doc/D/y/Dynamic_format.html

--
Ed Carp, N7EKG  -  [EMAIL PROTECTED]  -  214/341-4420 - http://www.pobox.com/~erc

Squished Mosquito, Inc.
Internet Applications Development
Escapade Server-Side Scripting Language Development Team
http://www.squishedmosquito.com
Pensacola - Dallas - Dresden - London

-
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




Re: In the table Properties... What is Row_Format???

2001-09-07 Thread Jeremy Zawodny

On Fri, Sep 07, 2001 at 12:56:14PM -0300, Pablo Fraga wrote:

 What´s the diference between The row storage format (Fixed, Dynamic,
 or Compressed) .
 
 I'am experiencing problems with update statements which goes against
 a table with the row_format property set to Fixed.

Fixed rows always use the same amount of space.  Dynamic do not.
Compressed rows are read-only.

Read more in the manual:

  http://www.mysql.com/doc/M/y/MyISAM_table_formats.html

Jeremy
-- 
Jeremy D. Zawodny, [EMAIL PROTECTED]
Technical Yahoo - Yahoo Finance
Desk: (408) 349-7878   Fax: (408) 349-5454   Cell: (408) 685-5936

MySQL 3.23.41-max: up 2 days, processed 42,309,448 queries (237/sec. avg)

-
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