mysql, add index

alter table MYTABLE add primary key ( MYID );

alter table MYTABLE add index  MYCOL ( MYCOL );

show index from MYTABLE;

참고: http://www.webmadang.net/database/database.do?action=read&boardid=4003&page=2&seq=10