---
title: MySQL笔记： 关于存储引擎
date: 2017-03-31 21:02:00
updated: 2017-03-31 21:02:00
description: "关于存储引擎"
categories: [个人笔记]
tags: [MySQL, MySQL笔记]
---

```sql
-- 1. 查看引擎
SHOW ENGINES;

-- 2. 修改默认引擎
-- 修改my.ini 后重启
-- default-storage-engine=INNODB  增删较好
-- default-storage-engine=MYISAM   支持全文索引，查询较好

USE xxxcompany;
SET default_storge_engine = INNODB;
SET default_storge_engine = MYISAM;

-- 3.指定表格使用引擎
CREATE TABLE student (stuId INT,stuName VARCHAR(20));
CREATE TABLE student (stuId INT,stuName VARCHAR(20)) ENGINE = MYISAM;

DROP TABLE student;
SHOW CREATE TABLE student;
```