MAX_ROWS

2002-06-18 Thread Aborla.net - webmaster
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???

HEAP tables

2002-06-16 Thread Aborla.net - webmaster
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