2021-08-08 mysql索引

– 显示所有的索引
SHOW INDEX FROM student

– 增加索引

ALTER TABLE student ADD FULLTEXT studentname(studentname)

– 分析sql语句执行状况

EXPLAIN SELECT * FROM student;

EXPLAIN SELECT * FROM student WHERE MATCH(studentname) AGAINST(‘李’) – 使用全文索引 真正使用不需要EXPLAIN