search

Home >Database >Mysql Tutorial >mysql查看表使用的发动机

mysql查看表使用的发动机

WBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWB
WBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOriginal
2016-06-07 16:16:131084browse

mysql查看表使用的引擎 show table status from 数据库名 where name=表名; 对其进行更改： alter table 表名 engine=innodb; alter table 表名 engine=myisam;

mysql查看表使用的引擎
show table status from 数据库名 where name=表名;

对其进行更改：
alter table 表名 engine=innodb;

alter table 表名 engine=myisam;
Statement：
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Previous article：如何修复MySQL数据库表Next article：MySQL数据库系统参数的优化

Related articles

See more