Home > Database > Mysql Tutorial > Mysql 加索引_MySQL

Mysql 加索引_MySQL

WBOY
Release: 2016-06-01 13:12:20
Original
915 people have browsed it

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); //增加索引



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