mysql数据库索引操作

1.查看表中索引

show index from tablename

2.对表创建索引

create index index_name on table_name (column1, column2)

3.删除索引
drop index index_name on talbe_name