show variables like 'table_type'; (MySQL 4) show variables like 'storage_engine'; (MySQL 5)
Both of these work. However, in future releases of MySQL table_type will goes away because it was kept from backward compatiblity with MySQL 4 ----- Original Message ----- From: Mike Kruckenberg <[EMAIL PROTECTED]> To: John Kopanas <[EMAIL PROTECTED]> Cc: mysql@lists.mysql.com Sent: Friday, November 17, 2006 12:32:19 PM GMT-0500 US/Eastern Subject: Re: How Do I Know If mySQL is using MyISAM or InnoDB? For any specific table if you do: show create table <tablename>; It will tell you what the able was created using. To create tables using a specific engine add ENGINE=<name> to the end of your create statement. To see the default that is used (I think this is what the table_type variable does): mysql> show variables like 'table_type'; +---------------+--------+ | Variable_name | Value | +---------------+--------+ | table_type | MYISAM | +---------------+--------+ 1 row in set (0.00 sec) John Kopanas wrote: > Is there a command at the command line that can tell me if I am using > MyISAM > or InnoDB? Thanks :-). > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
