>how can I get the type of a table (MyISAM, InnoDB, Berkeley DB)
>by a given table name with sql?
select engine
from information_schema.tables
where table_schema='dbname' and table_name='tblname';
PB
Marten Lehmann wrote:
> Hello,
>
> how can I get the type of a table (MyISAM, InnoDB, Berkeley DB) by a
> given table name with sql?
>
> Regards
> Marten
>
--
No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.1.411 / Virus Database: 268.17.28/672 - Release Date: 2/6/2007
