Hello,
I created a table using:
"CREATE TABLE a (pa VARCHAR (255) NOT NULL, pi VARCHAR (255), PRIMARY KEY
(pa)) TYPE=HEAP MAX_ROWS=10"
Then I inserted 16 recors. Later I done SELECT * FFROM a and mysql returned
16 records. Why this??? Does i should return only the last 10 records I
inserted???
Hello everybody,
I have two questions:
1) If I create a table with MAX_ROWS=10 and I insert 10 records. Then I
insert more 3 records. Does mysql delete older records and insert new ones??
2) I created a table using this:
CREATE TABLE a (pa VARCHAR (255) NOT NULL, pi VARCHAR (255), PRIMARY KEY
(p