how to see the storage engine of a mysql table

you can use the
mysql> show create table TABLE_NAME
command to see the engine of a table.
the response should be like that:

Create Table: CREATE TABLE t (
id INT(11) default NULL auto_increment,
s char(60) default NULL,
PRIMARY KEY (id)
) ENGINE=MyISAM