I believe there is an extra byte for the 'null' flag; if you declare this column to be NOT NULL, I'll bet the avg length will be 10.
-steve At 10:43 PM +0100 1/14/03, Stefan Hinz wrote:
Dear gurus, here's my final stupid question for today. Why is the average row length 11 when it should be 10? mysql> DESCRIBE myrowisam; +-------+----------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +-------+----------+------+-----+---------+-------+ | col | char(10) | YES | | NULL | | +-------+----------+------+-----+---------+-------+ mysql> SHOW TABLE STATUS LIKE 'myrow%'; +-------------+--------+------------+------+----------------+ | Name | Type | Row_format | Rows | Avg_row_length | +-------------+--------+------------+------+----------------+ | myrowisam | MyISAM | Fixed | 68 | 11 | <--- TIA, -- Stefan Hinz <[EMAIL PROTECTED]> Geschäftsführer / CEO iConnect GmbH <http://iConnect.de> Heesestr. 6, 12169 Berlin (Germany) Tel: +49 30 7970948-0 Fax: +49 30 7970948-3
-- +------------------------------------------------------------------------+ | Steve Edberg [EMAIL PROTECTED] | | University of California, Davis (530)754-9127 | | Programming/Database/SysAdmin http://pgfsun.ucdavis.edu/ | +------------------------------------------------------------------------+ | SETI@Home: 1001 Work units on 23 oct 2002 | | 3.152 years CPU time, 3.142 years SETI user... and STILL no aliens... | +------------------------------------------------------------------------+ --------------------------------------------------------------------- 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