
复制mysql> show engines; +--------------------+---------+------------------------------------------------------------+--------------+-----+------------+ | Engine | Support | Comment | Transactions | XA | Savepoints | +--------------------+---------+------------------------------------------------------------+--------------+-----+------------+ | InnoDB | DEFAULT | Supports transactions,用M于 row-level locking, andforeign keys | YES | YES | YES | | PERFORMANCE_SCHEMA | YES | Performance Schema | NO | NO | NO | | CSV | YES | CSV storage engine | NO | NO | NO | | MRG_MYISAM | YES | Collection of identical MyISAM tables | NO | NO | NO | | MyISAM | YES | MyISAM storage engine | NO | NO | NO | | MEMORY | YES | Hash based, stored in memory, useful fortemporary tables | NO | NO | NO | +--------------------+---------+------------------------------------------------------------+--------------+-----+------------+ 6 rowsinset 1.2.3.4.5.6.7.8.9.10.11.12.