![在这里插入图片描述](https://img-blog.csdnimg.cn/direct/b40dbf4fa53142c0a03246e6734f51db.png)
CREATE INDEX empno_index ON emp(empno)
SELECT * FROM emp
WHERE empno = 1234568
索引增删改查
CREATE TABLE t25(
id INT,
`name` VARCHAR(32));
SHOW INDEXES FROM t25;
CREATE UNIQUE INDEX id_index ON t25(id);
CREATE INDEX id_index ON t25(id);
ALTER TABLE t25 ADD INDEXES id_index(id)
CREATE TABLE t26(
id INT PRIMARY KEY,
`name` VARCHAR(32));
ALTER TABLE t25 ADD PRIMARY KEY(id)
DROP INDEX id_index ON t25
ALTER TABLE t26 DROP PRIMARY KEY
SHOW INDEXES FROM t25;
SHOW INDEX FROM t25;
SHOW KEYS FROM t25;
DESC t25;
添加规则
![在这里插入图片描述](https://img-blog.csdnimg.cn/direct/df2b18bdc0314ba6b6915d215a61bc45.png)