Home  >  Article  >  Database  >  mysql 查看存储引擎_MySQL

mysql 查看存储引擎_MySQL

WBOY
WBOYOriginal
2016-06-01 13:51:521103browse

查看mysql的存储引擎:

 mysql>show engines;

查看默认的搜索引擎:

mysql>show variables like '%storage_engine%';

查看某个表用的什么引擎

show create table 表名;

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