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

15 votes208 views5 answers
Show tables in oracle
SQL
2 votes155 views1 answer
Oracle run_duration average
SQL
1 vote171 views3 answers
Psql: error: FATAL: role "postgres" does not exist
SQL
0 vote165 views1 answer
Oracle sql winter time change
SQL
1 vote218 views2 answers
Login to mysql
SQL
1 vote160 views1 answer
Psql datetime grather than
SQL
1 vote166 views2 answers
Duplicate key value violates unique constraint "django_admin_log_pkey"
SQL
0 vote171 views1 answer
Mysql backup certain tables workbench
SQL
0 vote218 views1 answer
Mysql row generator
SQL
0 vote187 views1 answer
Simple plsql program run in oracle sql developer but got the error
SQL