Re: innodb madness

2007-02-06 Thread Rolando Edwards
Chris White" <[EMAIL PROTECTED]> To: "Marten Lehmann" <[EMAIL PROTECTED]> Cc: mysql@lists.mysql.com Sent: Tuesday, February 6, 2007 1:24:46 PM (GMT-0500) US/Eastern Subject: Re: innodb madness Marten Lehmann wrote: > How can I check which tables are using innodb with sql? How

Re: innodb madness

2007-02-06 Thread Chris White
Marten Lehmann wrote: How can I check which tables are using innodb with sql? How can walk through the tables with "show databases" and "show tables". Thanks. This somewhat depends on how the tables were declared. If you used "ENGINE=InnoDb;" in the CREATE TABLE sequence, you'd be able to lo