修改表时创建索引的正确格式是?
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
修改表时创建索引的正确格式是?
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