dcsimg
 

Submitted by: M S Sridhar(sridhar.ms@gmail.com)

Thursday Oct 25th 2018 by M S Sridhar

Language: SQL, Expertise: Intermediate - There are plenty of commands in MySQL that are supported for particular types of storage engines. Use this command to know the engine type.

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   |               |        |
+--------------+--------+-------+-----------+-----+---------------+------------+----------------+-------------+----------+---------------+-----------------------+------------+-----------+----------+---------+---------------+--------+
Home
Mobile Site | Full Site