In the last episode (Oct 30), Bennett Haselton said:
> I created one table with the command:
>
> CREATE TABLE pet (name VARCHAR(20), owner VARCHAR(20), species VARCHAR(20), sex
>CHAR(1), birth DATE, death DATE, id INT UNSIGNED NOT NULL);
>
> and another one with the command:
>
> CREATE TABLE pet2 (name VARCHAR(20), owner VARCHAR(20), species VARCHAR(20), sex
>CHAR(1), birth DATE, death DATE, id INT UNSIGNED NOT NULL) ROW_FORMAT=compressed;
>From the manual:
: `ROW_FORMAT' Defines how the rows should be stored. Currently
: this option only works with MyISAM tables, which
: supports the `DYNAMIC' and `FIXED' row formats.
: *Note MyISAM table formats::.
: When you `CREATE' or `ALTER' a table you can for tables that
: doesn't have `BLOB''s force the table format to `DYNAMIC' or
: `FIXED' with the `ROW_FORMAT=#' table option. In the future you
: will be able to compress/decompress tables by specifying
: `ROW_FORMAT=compressed | default' to `ALTER TABLE'. *Note CREATE
: TABLE::.
--
Dan Nelson
[EMAIL PROTECTED]
---------------------------------------------------------------------
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
