修改表时创建索引的正确格式是？
A.alter table student add index index1(sname)
B.alter table student add index index1(sname(10))
C.modify table student add index index1(sname(10))
D.modify table student add index index1(sname)
正确答案是B