1.查看表引擎
show create table user;
+-------+--------------------------------------------------------------------------------------------------------------------------------+
| Table | Create Table |
+-------+--------------------------------------------------------------------------------------------------------------------------------+
| user | CREATE TABLE `user` (
`name` varchar(50) DEFAULT NULL,
`account` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 |
+-------+--------------------------------------------------------------------------------------------------------------------------------+
1 row in set (0.00 sec)
2.修改引擎类型
将user表的引擎由InnoDB改为MyISAM。
alter table user engine=MyISAM
查看表引擎。
show create table user;
+-------+--------------------------------------------------------------------------------------------------------------------------------+
| Table | Create Table |
+-------+--------------------------------------------------------------------------------------------------------------------------------+
| user | CREATE TABLE `user` (
`name` varchar(50) DEFAULT NULL,
`account` int(11) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 |
+-------+--------------------------------------------------------------------------------------------------------------------------------+
1 row in set (0.00 sec)