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