How we can create index in mysql?

You can use
CREATE INDEX [index name] ON [table name]([column name]);