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 <hinz@stripped>
> 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 sbedberg@stripped |
| 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... |
+------------------------------------------------------------------------+
