mysql> show create table gateway ; +---------+------------------------------------ | Table | Create Table | +---------+------------------------------------- | gateway | CREATE TABLE `gateway` ( `dns` varchar(40) DEFAULT NULL, `gateway_site` varchar(3) DEFAULT NULL, `gateway_funct` varchar(15) DEFAULT NULL, `gateway_ip` varchar(15) DEFAULT NULL, `gateway_oct1` varchar(3) DEFAULT NULL, `gateway_oct2` varchar(3) DEFAULT NULL, `gateway_oct3` varchar(3) DEFAULT NULL, `gateway_oct4` varchar(3) DEFAULT NULL, `comment` varchar(128) DEFAULT NULL ) ENGINE=MyISAM DEFAULT CHARSET=utf8 | +---------+------------------------------ 1 row in set (0.00 sec) mysql> mysql> show table status like 'gateway' ; +---------+--------+---------+------------+------+----------------+-------------+-----------------+--------------+-----------+----------------+---------------------+---------------------+------------+-----------------+----------+----------------+---------+ | Name | Engine | Version | Row_format | Rows | Avg_row_length | Data_length | Max_data_length | Index_length | Data_free | Auto_increment | Create_time | Update_time | Check_time | Collation | Checksum | Create_options | Comment | +---------+--------+---------+------------+------+----------------+-------------+-----------------+--------------+-----------+----------------+---------------------+---------------------+------------+-----------------+----------+----------------+---------+ | gateway | MyISAM | 10 | Dynamic | 69 | 85 | 5924 | 281474976710655 | 1024 | 0 | NULL | 2009-08-11 14:59:58 | 2009-11-19 00:11:51 | NULL | utf8_general_ci | NULL | | | +---------+--------+---------+------------+------+----------------+-------------+-----------------+--------------+-----------+----------------+---------------------+---------------------+------------+-----------------+----------+----------------+---------+ 1 row in set (0.00 sec) mysql>