mysql> select count(*) from mythlog; +----------+ | count(*) | +----------+ | 599 | +----------+ 1 row in set (0.00 sec) mysql> describe mythlog; +--------------+------------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +--------------+------------------+------+-----+---------+----------------+ | logid | int(10) unsigned | | PRI | NULL | auto_increment | | module | varchar(32) | | | | | | priority | int(11) | | | 0 | | | acknowledged | tinyint(1) | YES | | 0 | | | logdate | datetime | YES | | NULL | | | host | varchar(128) | YES | | NULL | | | message | varchar(255) | | | | | | details | text | YES | | NULL | | +--------------+------------------+------+-----+---------+----------------+ 8 rows in set (0.00 sec)