mysql的几种表类型,MySql的七种表类型(存储引擎)

root@(none) 02:21:54>show engines;

+--------------------+---------+----------------------------------------------------------------------------+--------------+------+------------+

| Engine | Support | Comment | Transactions | XA | Savepoints |

+--------------------+---------+----------------------------------------------------------------------------+--------------+------+------------+

| 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 |

| BLACKHOLE | YES | /dev/null storage engine (anything you write to it disappears) | NO | NO | NO |

| MyISAM | YES | MyISAM storage engine | NO | NO | NO |

| MEMORY | YES | Hash based, stored in memory, useful for temporary tables | NO | NO | NO |

| ARCHIVE | YES | Archive storage engine | NO | NO | NO |

| FEDERATED | NO | Federated MySQL storage engine | NULL | NULL | NULL |

| InnoDB | DEFAULT | Percona-XtraDB, Supports transactions, row-level locking, and foreign keys | YES | YES | YES |

+--------------------+---------+----------------------------------------------------------------------------+--------------+------+------------+

9 rows in set (0.01 sec)

Mysql的存储引擎(表类型分为以下几种)

(1)MyISAM：具有较高的插入、查询速度，但是不支持事务。

(2)InnoDB：支持事务、支持行级锁

(3)MEMORY：

(4)ARCHIVE:

(5)CSV存储引擎将数据以逗号分隔的形式存储在文本文件中

创建数据库表的时候可以通过engine来选定要创建何种类型的存储表

create table tablename (...,...,...,) ENGINE = INNODB