List:General Discussion« Previous MessageNext Message »
From:Rolando Edwards Date:February 6 2007 6:37pm
Subject:Re: detecting the table type by sql?
View as plain text  
This is of course MySQL 5

SELECT engine FROM information_schema.tables
WHERE table_schema='...' AND table_name='...';

I haven't used MySQL 4
Maybe this might help
SHOW CREATE TABLE <tbl-name>;

You should see TYPE=MyISAM or TYPE=BDB or some other engine in the string

----- Original Message -----
From: "Marten Lehmann" <lehmann@stripped>
To: mysql@stripped
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

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/mysql?unsub=1


Thread
detecting the table type by sql?Marten Lehmann6 Feb
  • Re: detecting the table type by sql?Peter Brawley6 Feb
  • Re: detecting the table type by sql?Philip Mather6 Feb
  • Re: detecting the table type by sql?Philip Mather6 Feb
  • Re: detecting the table type by sql?Rolando Edwards6 Feb