In the last episode (Jan 14), Stefan Hinz said: > 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 | <---
* Each `NULL' column takes one bit extra, rounded up to the nearest byte. -- Dan Nelson [EMAIL PROTECTED] --------------------------------------------------------------------- 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