Marten
In more recent version you can do a simple...
SELECT ENGINE FROM TABLES WHERE TABLE_SCHEMA = "{database name}" AND
TABLE_NAME = "{table name}";
...dunno how you'd do it on older versions exactly, you can do...
SHOW TABLE STATUS WHERE Name = "BID_UNIQUE_IDS";
...but you can't select individual fields from that.
Regards,
Phil
Hello,
how can I get the type of a table (MyISAM, InnoDB, Berkeley DB) by a
given table name with sql?
Regards
Marten
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]