This is in 4.0, it has changed in more recent versions.
Mike Kruckenberg wrote:
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]
