Try the describe mysql command.
Code:
mysql> describe npc_types;
+-------------------+---------------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+-------------------+---------------------+------+-----+---------+----------------+
| id | int(11) | | PRI | NULL | auto_increment |
| name | text | | | | |
| level | tinyint(2) unsigned | | | 0 | |
| race | tinyint(2) unsigned | | | 0 | |
| class | tinyint(2) unsigned | | | 0 | |
| hp | int(11) | | | 0 | |
| gender | tinyint(2) unsigned | | | 0 | |
| texture | tinyint(2) unsigned | | | 0 | |
| helmtexture | tinyint(2) unsigned | | | 0 | |
| size | float | | | 0 | |
| hp_regen_rate | int(11) unsigned | | | 0 | |
| mana_regen_rate | int(11) unsigned | | | 0 | |
| loottable_id | int(11) unsigned | | | 0 | |
| merchant_id | int(11) unsigned | | | 0 | |
| mindmg | int(10) unsigned | | | 0 | |
| maxdmg | int(10) unsigned | | | 0 | |
| usedspells | varchar(70) | | | | |
| npcspecialattks | char(1) | | | | |
| banish | int(10) unsigned | | | 0 | |
| aggroradius | int(10) unsigned | | | 0 | |
| social | int(10) unsigned | | | 0 | |
| face | int(10) unsigned | | | 1 | |
| luclin_hairstyle | int(10) unsigned | | | 1 | |
| luclin_haircolor | int(10) unsigned | | | 1 | |
| luclin_eyecolor | int(10) unsigned | | | 1 | |
| luclin_beardcolor | int(10) unsigned | | | 1 | |
| fixedz | tinyint(2) unsigned | | | 0 | |
| d_meele_texture1 | int(10) unsigned | | | 0 | |
| d_meele_texture2 | int(10) unsigned | | | 0 | |
| walkspeed | float | | | 0 | |
| runspeed | float | | | 0 | |
+-------------------+---------------------+------+-----+---------+----------------+
31 rows in set (0.01 sec)