Home >Database >Mysql Tutorial >Mysql 加索引_MySQL
Mysql 加索引_MySQL
- WBOYOriginal
- 2016-06-01 13:12:20898browse
ALTER TABLE S_LY_NOTE_DATA(表名) DROP INDEX index_cs(索引名) //删除索引
SHOW INDEX FROM S_LY_NOTE_DATA; //查看索引
CREATE INDEX index_c ON S_LY_NOTE_DATA(title, sid); //增加索引
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学习笔记之六 向数据表插入行记录_MySQLNext article：Mysql Union实例_MySQL