Home > Database > Mysql Tutorial > 查看mysql发动机

查看mysql发动机

WBOY
Release: 2016-06-07 16:24:48
Original
1161 people have browsed it

查看mysql引擎 一般情况下,mysql会默认提供多种存储引擎,你可以通过下面的查看: 看你的mysql现在已提供什么存储引擎: mysql show engines; 看你的mysql当前默认的存储引擎: mysql show variables like '%storage_engine%'; 你要看某个表用了什么引擎(在显示

查看mysql引擎
一般情况下,mysql会默认提供多种存储引擎,你可以通过下面的查看:<br><br>看你的mysql现在已提供什么存储引擎:<br>mysql> show engines;<br><br>看你的mysql当前默认的存储引擎:<br>mysql> show variables like '%storage_engine%';<br><br>你要看某个表用了什么引擎(在显示结果里参数engine后面的就表示该表当前用的存储引擎):<br>mysql> show create table 表名
Copy after login
source:php.cn
Statement of this Website
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
Popular Tutorials
More>
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template