This is will tell you your default storage engine type should you create a table without specifying an engine:
show variables like 'storage engine'; If you want to create a table with a specific engine, specify it at the end od the CREATE TABLE like this: CREATE TABLE ( ... ) ENGINE=MyISAM; CREATE TABLE ( ... ) ENGINE=InnoDB; To show what engines are available on your MySQL server, do this: show engines; ----- Original Message ----- From: John Kopanas <[EMAIL PROTECTED]> To: mysql@lists.mysql.com Sent: Friday, November 17, 2006 12:13:33 PM GMT-0500 US/Eastern Subject: How Do I Know If mySQL is using MyISAM or InnoDB? Is there a command at the command line that can tell me if I am using MyISAM or InnoDB? Thanks :-). -- John Kopanas [EMAIL PROTECTED] http://www.kopanas.com http://www.cusec.net http://www.soen.info -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
