索引的创建和删除

//添加普通索引
CREATE index economy_organization_id on economy_organization(id)
//添加非空索引
CREATE UNIQUE INDEX economy_organization_id ON economy_organization (id) ;
//添加主键索引
CREATE PRIMARY INDEX economy_organization_id ON economy_organization (id) ;


//删除索引
drop index economy_organization_id on economy_organization ;
查询所有的索引
show index from economy_organization 
上一篇:swagger文档分组显示


下一篇:【Computer Organization笔记12】流水线技术概述