1.添加PRIMARY KEY(主键索引)
mysql>ALTER TABLE `table_name` ADD PRIMARY KEY ( `column` )
mysql>ALTER TABLE `table_name` ADD UNIQUE (
)
mysql索引
原文:http://www.cnblogs.com/xbblogs/p/5999906.html