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