mysql 创建索引,删除索引的sql语句 【转】

create unique index customer_info_index1 on customer_info(number);--创建唯一索引
create index customer_info_index2 on customer_info(name);--创建索引
drop index user_info_index1 on user_info; --删除索引

mysql查询表结构的语句

show columns from talbe_name;