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???

Please help me


Nuno Lopes




-
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

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
(pa)) TYPE=HEAP MAX_ROWS=10

Then I have 16 (SIXTEEN) records. Why this. I think the max rows is
10?!?!?!?

Can anybody help me???


Thanking in advance,
Nuno Lopes




-
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