Mysql索引-白红宇

Mysql索引

阅读量：93 次

发布时间：2019-02-25

本文共 1505 字，大约阅读时间需要 5 分钟。

MySQL?????????????

??????????????????????????????????????????????????????????????????????????????MySQL???

????????

???MySQL??????????????????????????????????????????????????????????????????????????????????MySQL??????????????????????????

???????

??????????????IO??????????????????????????????????????????????????B+??????????????????????????IO???

B+??????

B+????????????????????????????????????

???????????????????????????IO???

?????????????????????????????

?????????????????????

???????????????????????IO???????????????????????

B+????

?????????????

????????????????????int??????????????????????

??????????

B+???????????????????????????????????????????

??????

????????????????????????????

??????????

1. ????

?????????????????

????????????????????

?????????????????????

??????????????????????????

2. ??????

???????ID??????????????????

?????????????????????????

???????????????????????

?????????

1. ????

??????????

create table s1(  id int,  name varchar(20),  gender char(6),  email varchar(50),  primary key(id));

create index idx_name on s1(name);

???????
```
create index idx_id on s1(id);
```

?????
```
drop index idx_name on s1;
```

2. ??????

?????????????????????????

??????????????????????

??????????????????

?????????

???????????????????

??????email LIKE '%cn%'?

??????reverse(email) = 'wupeiqi'?

???????????nid != 123??nid???????????

???????

????????????????????

????*????????????

?????????????????????

??

????????????????????????????????????????IO???????????????????????????????????????????????????????????????????

转载地址：http://oqt.baihongyu.com/

你可能感兴趣的文章

Oracle闪回技术(Flashback)

查看>>

oracle零碎要点---ip地址问题,服务问题,系统默认密码问题

查看>>

oracle零碎要点---oracle em的web访问地址忘了

查看>>

Oracle零碎要点---多表联合查询,收集数据库基本资料

查看>>

Oracle静默安装

查看>>

Oracle面试题：Oracle中truncate和delete的区别

查看>>

Oracle：ORA-00911: 无效字符

org.apache.ibatis.exceptions.TooManyResultsException: Expected one result (or null) to be returned

查看>>

org.apache.poi.hssf.util.Region

查看>>

org.apache.zookeeper.KeeperException$ConnectionLossException: KeeperErrorCode = ConnectionLoss for /

查看>>

org.hibernate.HibernateException: Unable to get the default Bean Validation factory

查看>>

org.springframework.orm.hibernate3.support.OpenSessionInViewFilter

查看>>

org.springframework.orm.hibernate3.support.OpenSessionInViewFilter

查看>>

org.springframework.web.multipart.MaxUploadSizeExceededException: Maximum upload size exceeded

查看>>

org.tinygroup.serviceprocessor-服务处理器

查看>>

org/eclipse/jetty/server/Connector : Unsupported major.minor version 52.0

查看>>

org/hibernate/validator/internal/engine

查看>>

SQL-36 创建一个actor_name表，将actor表中的所有first_name以及last_name导入改表。

查看>>