Show table status\G Will give you a list of tables the Type: field for each table is the storage engine. Your installation probably defaults to MyISAM
-Eric On Mon, 28 Jun 2004 11:51:40 -0400, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: > > > You can see a list of the available storage types with SHOW ENGINES > > To see which engine is in use for any table you can SHOW TABLE STATUS or > SHOW CREATE TABLE <tablename> > > All of these commands, and more, are documented at : > http://dev.mysql.com/doc/mysql/en/SHOW.html > > Yours, > Shawn Green > Database Administrator > Unimin Corporation - Spruce Pine > > "Scott Fletcher" > <[EMAIL PROTECTED] To: <[EMAIL PROTECTED]> > com> cc: > Fax to: > 06/28/2004 11:27 Subject: MySQL Storage Engines and > Table Types..... > AM > > > > > Hi! > > How do I know which of the storage engine am I using or running, or > whatever that use the databases/tables? > > Thanks, > Scott F. > > -- > 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]
