anybody knows when row_format=compressed will work?
and what means row_format=default? . that it´s not compressed?
thanks
__
WEB.DE FreeMail wird 5 Jahre jung! Feiern Sie mit uns und
nutzen Sie die neuen Funktionen
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 manu
>
> 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 o
CHAR(1), birth DATE, death DATE, id INT UNSIGNED NOT NULL) ROW_FORMAT=compressed;
and then populated both of them with 10,000 rows of data, from a file "pet.txt" with
10,000 lines of text, created with the perl script:
>>>
open(PET, "> pet.txt");
for (my $i = 1;
