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
mysql> use db;
mysql>SHOW CREATE TABLE tablename ;
OR
mysql>SHOW table status;


:)
chandranjoy
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 2 guests


cron