mysql怎么创建索引？

索引类型	建表时	建表后
主键索引	create table t(id int primary key); create table t(id int, primary key(id));	alter table t add primary key(id);
单值索引	create table t(a int, index(a)); create table t(a int, key(a)); create table t(a int, index index_name (a));	alter table t add index (a); alter table t add key (a); alter table t add index index_name (a); alter table t add key key_name (a); create index index_name on t(a);
唯一索引	create table t(a int unique); create table t(a int, unique(a)); create table t(a int, unique unique_name (a)); create table t(a int, unique index index_name (a)); create table t(a int, unique key key_name (a));	alter table t add unique (a); alter table t add unique unique_name (a); alter table t add unique index (a); alter table t add unique key (a); alter table t add unique index index_name (a); alter table t add unique key key_name (a); create unique index index_name on t(a);
复合索引	create table t(a int, b int, index(a,b)); create table t(a int, b int, key(a,b)); create table t(a int, b int, index index _name (a,b)); create table t(a int, b int, key key_name (a,b));	alter table t add index (a,b); alter table t add key (a,b); alter table t add index index_name (a,b); alter table t add key key_name (a,b); create index index_name on t(a,b);