Alter Table语法

http://dev.mysql.com/doc/refman/5.1/en/alter-table.html

添加索引

ALTER　table tab1 add key(或index) key_name (col1);

添加前缀索引

ALTER　table tab1 add key(或index) key_name (col1(10));