There are plenty of commands in MySQL that are supported for particular types of storage engines.

We can use the following command to know the ENGINE type.

SHOW TABLE STATUS WHERE NAME ='STOCKPRICE'

Here, NAME is the name of the TABLE (In this case, it is STOCKPRICE)

Sample output:

+--------------+--------+-------+-----------+-----+---------------+------------+----------------+-------------+----------+---------------+-----------------------+------------+-----------+----------+---------+---------------+--------+|Name          |Engine  |Version|Row_format |Rows |Avg_row_length |Data_length |Max_data_length |Index_length |Data_free |Auto_increment |Create_time            |Update_time |Check_time |Collation |Checksum |Create_options |Comment |+--------------+--------+-------+-----------+-----+---------------+------------+----------------+-------------+----------+---------------+-----------------------+------------+-----------+----------+---------+---------------+--------+|  STOCKPRICE  | InnoDB |  10   |  Compact  |  3  |  5461         |  16384     |  0             |  0          |  0       |  NULL         |  2018-01-16 17:56:09  |  NULL      |  NULL     |  utf8_bin|  NULL   |               |        |+--------------+--------+-------+-----------+-----+---------------+------------+----------------+-------------+----------+---------------+-----------------------+------------+-----------+----------+---------+---------------+--------+