查看表的索引
show keys from tablename
为表添加索引
create index indexname on tablename ( column1, column2)
删除表的索引
drop index indexname on tablename
添加主键索引
alter table tablename add primary key ( column1 )
