Create index mysql cli

create index your_index_name on your_table_name(your_column_name) using HASH;
or
create index your_index_name on your_table_name(your_column_name) using BTREE;

Source: stackoverflow.com

How to create index mysql

# index_name will identify your index for future reference
CREATE INDEX index_name ON table_name (column_name);

Similar codes

0 vote146 views1 answer
Foreign key multiple columns
SQL
10 votes142 views2 answers
SQL rounding numbers
SQL
0 vote131 views2 answers
How to combine diff colmun value using group by postgres
SQL
2 votes138 views2 answers
How to rename column name in sql server using query
SQL
0 vote141 views1 answer
Mysql workbench procedure
SQL
21 votes135 views5 answers
Oracle all tables
SQL
3 votes147 views2 answers
How to force truncate a table in mysql
SQL
0 vote142 views1 answer
Mysql workbench primary key
SQL
0 vote98 views1 answer
Mariadb list tables
SQL
10 votes136 views4 answers
Primary key sql
SQL