Add new MySQL table columns and creating indexes

Question

I have this existing query to create an additional MySQL column to an existing table.:

$wpdb->query("ALTER TABLE mytable ADD COLUMN myarguments VARCHAR(255)");  

How can I also create indexes while adding new column?

Answer 1

combine it adding comma, eg

ALTER TABLE mytable      ADD COLUMN myarguments VARCHAR(255),      ADD INDEX (myarguments); 

• SQLFiddle Demo