Board index Linux Mysql

Moderator: chandranjoy

How to find out the table Storage engine in MySQL

Postby chandranjoy » Tue Dec 28, 2010 7:22 pm

How do I tell if a table is created by using the InnoDB or MyISAM storage engine?
mysql> use db;
mysql>SHOW CREATE TABLE tablename ;
mysql>SHOW table status;

Site Admin
Posts: 283
Joined: Fri Oct 23, 2009 11:19 pm

Return to Mysql

Who is online

Users browsing this forum: No registered users and 1 guest