mysql表引擎修改

1、修改建表引擎

mysql> CREATE TABLE test_2(    -> name varchar(10),    -> year int(10))    -> ENGINE=InnoDB;            -->建立表時指定預設引擎Query OK, 0 rows affected (0.10 sec)mysql> show create table test_2\G*************************** 1. row ***************************       Table: test_2Create Table: CREATE TABLE `test_2` (  `name` varchar(10) DEFAULT NULL,  `year` int(10) DEFAULT NULL) ENGINE=InnoDB DEFAULT CHARSET=latin11 row in set (0.00 sec)mysql>mysql> show tables;+------------------+| Tables_in_excise |+------------------+| test1            || test_1           |+------------------+2 rows in set (0.00 sec)mysql> show create table test_1\G*************************** 1. row ***************************       Table: test_1Create Table: CREATE TABLE `test_1` (  `name` varchar(20) DEFAULT NULL,  `year` int(5) DEFAULT NULL) ENGINE=MyISAM DEFAULT CHARSET=latin1     --> 預設的表引擎為MyISAM;1 row in set (0.00 sec)mysql> alter table test_1 type=InnoDB;  -->  修改表的資料引擎;Query OK, 0 rows affected, 1 warning (0.11 sec)Records: 0  Duplicates: 0  Warnings: 0mysql> show create table test_1\G*************************** 1. row ***************************       Table: test_1Create Table: CREATE TABLE `test_1` (  `name` varchar(20) DEFAULT NULL,  `year` int(5) DEFAULT NULL) ENGINE=InnoDB DEFAULT CHARSET=latin1  --> 顯示表的資料引擎已經變為InnoDB;1 row in set (0.00 sec)mysql>

2、

mysql> show engines;   -->  查看MySQL支援引擎   +------------+---------+------------------------------------------------------------+--------------+------+------------+| Engine     | Support | Comment                                                    | Transactions | XA   | Savepoints |+------------+---------+------------------------------------------------------------+--------------+------+------------+| MRG_MYISAM | YES     | Collection of identical MyISAM tables                      | NO           | NO   | NO         || CSV        | YES     | CSV storage engine                                         | NO           | NO   | NO         || MyISAM     | DEFAULT | Default engine as of MySQL 3.23 with great performance     | NO           | NO   | NO         || InnoDB     | YES     | Supports transactions, row-level locking, and foreign keys | YES          | YES  | YES        || MEMORY     | YES     | Hash based, stored in memory, useful for temporary tables  | NO           | NO   | NO         |+------------+---------+------------------------------------------------------------+--------------+------+------------+5 rows in set (0.00 sec)mysql>