1. 查看索引
SHOW INDEX FROM <表名> [ FROM <数据库名>]
实际:SHOW INDEX FROM terminal;
查询结果:
2. 创建索引
- 创建普通索引
CREATE INDEX index_name ON table_name (column_list) - 创建唯一索引
CREATE UNIQUE INDEX index_name ON table_name (column_list)
实际:CREATE INDEX index_device ON terminal (ter_number);
创建完之后,显示索引,索引创建成功: