mysql数据库索引

闲来无事学习数据库的索引

1.创建索引(普通索引，都是b+树索引)

create index idx_city_name on city(city_name)

2查看索引

show index  from city \G;

3.删除索引

drop index idx_city_name on city;

4创建其他索引

alter table city add unique idx_city_name(city_name);
alter table city add fulltext idx_city_name(city_name);