– 显示所有的索引
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
– 显示所有的索引
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