show variables like 'storage_engine'; I forgot the underscore in the lastmessage
----- Original Message ----- From: Rolando Edwards <[EMAIL PROTECTED]> To: John Kopanas <[EMAIL PROTECTED]> Cc: mysql@lists.mysql.com Sent: Friday, November 17, 2006 12:30:51 PM GMT-0500 US/Eastern Subject: Re: How Do I Know If mySQL is using MyISAM or InnoDB? 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]
