adding cluster index other than primary key default cluster index create table t1 (id int primary key auto_increment, name varchar(20))


In the above table id is primary key and by default cluster index is added to primary key column.

My question is, can we add cluster index on column (name) too??.
can we add cluster index on column (name) too?


No. Only one index is clustered. 

For MySQL: 


If primary key exists it is clustered. 
If no primary index but unique indexes exists then first unique index is clustered. 
If no unique indexes exists then the index by inner record number (hidden, unaccessable) is clustered one.