Query the search engine for MySQL

Enter the following command in MySQL

Query command:

Show engines;

Query Result:

+--------------------+---------+----------------------------------------------------------------+-------------- +------+------------+| Engine | Support | Comment | Transactions | XA | savepoints |+--------------------+---------+----------------------------------------------------------------+--- -----------+------+------------+| Federated | NO | Federated MySQL Storage Engine | NULL | NULL | NULL | | Mrg_myisam | YES | Collection of identical MyISAM tables | NO | NO | NO | | MEMORY | YES | Hash based, storedinchMemory, useful forTemporary Tables | NO | NO | NO | | Blackhole | YES | /dev/NULLStorage engine (anything you write to it disappears) | NO | NO | NO | | CSV | YES | CSV Storage Engine | NO | NO | NO | | MyISAM | YES | MyISAM Storage Engine | NO | NO | NO | | ARCHIVE | YES | Archive Storage Engine | NO | NO | NO | | InnoDB | DEFAULT | Supports transactions, Row-level locking, and foreign keys | YES | YES | YES | | Performance_schema | YES | Performance Schema | NO | NO | NO |+--------------------+---------+----------------------------------------------------------------+----------- ---+------+------------+

Specify search engines:

CREATE TABLE table_name (        int) ENGINE=myisam;

To modify a search engine:

ALTER TABLE table_name Engine=myisam;

To view a table's search engine:

Show creat table table_name;

Query the search engine for MySQL