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 | | |+--------------+--------+-------+-----------+-----+---------------+------------+----------------+-------------+----------+---------------+-----------------------+------------+-----------+----------+---------+---------------+--------+
Charlie has over a decade of experience in website administration and technology management. As the site admin, he oversees all technical aspects of running a high-traffic online platform, ensuring optimal performance, security, and user experience.
