When you are working in mysql server sometimes you need the information about what is the storage engine of table in database. Mostly we use Innodb and MyISAM but it might be the case in mysql server other storage engine can also be used.

In mysql to know storage engine of mysql table,use the below given command

Step 1 : Login into mysql server

mysql -u root -p

Step 2: Connect to database

use database-name

Step 3: Now hit the below given command in mysql prompt. See the second field “Engine”
Replace table-name with name of your mysql table name.

show table status where `Name` = 'table-name' G;

For live example from my system,below given is the reference

linux@tuxworld:~/Desktop/data3/data2$ mysql -u root -p
Enter password: 
Welcome to the MySQL monitor.  Commands end with ; or g.
Your MySQL connection id is 190
Server version: 5.5.29-0ubuntu0.12.10.1 (Ubuntu)

Copyright (c) 2000, 2012, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or 'h' for help. Type 'c' to clear the current input statement.

mysql> use linux
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Database changed
mysql> show table status where `Name` = 'tutorials_tbl' G;
*************************** 1. row ***************************
           Name: tutorials_tbl
         Engine: InnoDB
        Version: 10
     Row_format: Compact
           Rows: 1
 Avg_row_length: 16384
    Data_length: 16384
Max_data_length: 0
   Index_length: 0
      Data_free: 7340032
 Auto_increment: 2
    Create_time: 2013-08-10 16:16:13
    Update_time: NULL
     Check_time: NULL
      Collation: latin1_swedish_ci
       Checksum: NULL
 Create_options: 
        Comment: 
1 row in set (0.00 sec)

ERROR: 
No query specified

mysql>