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

5 votes189 views3 answers
How to remove unique key constraint in mysql
SQL
0 vote188 views2 answers
Mysql set foreign_key_checks=0
SQL
0 vote187 views1 answer
Mysql grant user privileges to database that has suffix and prefix
SQL
0 vote161 views1 answer
Prevent duplicate rows in postgres
SQL
0 vote195 views1 answer
Sql query to delete row by id
SQL
0 vote283 views1 answer
Shortcut run sql pgadmin
SQL
0 vote238 views1 answer
Alter fedora mysql 8.0 user
SQL
0 vote183 views1 answer
Oracle select invalid views
SQL
0 vote186 views1 answer
Power query case when
SQL
0 vote193 views1 answer
Mysql does collate nopad recognize space
SQL