On Tue, 2002-06-18 at 11:43, Aborla.net - webmaster wrote: > 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....
Hello Nuno! Sinisa answered this question for someone else on this mailing list earlier today. I will repeat it for you and for anyone following this thread later on in the archives. Sinisa wrote: Some table handler, like HEAP, use info you specify for max_rows and avg_row_length to determine maxumum number of blocks that could be use for given table. -- "Gosh, Batman. The nobility of the almost-human porpoise." --Robin __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Zak Greant <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Advocate /_/ /_/\_, /___/\___\_\___/ Calgary, Canada <___/ www.mysql.com Feed the Dolphin! Order MySQL support from the MySQL developers at https://order.mysql.com/?ref=mzgr --------------------------------------------------------------------- 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