创建索引:1、create table aa( id int, age varchar(10), index age_index(age))
2、CREATE index id_index ON aa(id)
删除索引:drop index age_index on aa