This is of course MySQL 5
SELECT engine FRM information_schema.tables
WHERE table_schema='' AND table_name='';
I haven't used MySQL 4
Maybe this might help
SHW CREATE TABLE <tbl-name>;
You should see TYPE=MyISAM or TYPE=BDB or some other engine in the string
Message
From: "Marten Lehmann" <lehmann (AT) cnm (DOT) de>
To: mysql (AT) lists (DOT) mysql.com
Sent: Tuesday, February 6, 2007 12:54:45 PM (GMT-0500) US/Eastern
Subject: detecting the table type by sql?
Hello,
how can I get the type of a table (MyISAM, InnoDB, Berkeley DB) by a
given table name with sql?
Regards
Marten