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 vote193 views1 answer
Disable database droping sql
SQL
13 votes185 views2 answers
Sqlite rename table
SQL
1 vote167 views1 answer
Count mysql server db tables
SQL
0 vote174 views1 answer
Mysql c commands
SQL
1 vote165 views1 answer
Oracle first row
SQL
3 votes168 views2 answers
Find the median in sql
SQL
0 vote170 views2 answers
Get top 1 row of each group
SQL
1 vote156 views1 answer
Error:Got a packet bigger than 'max_allowed_packet' bytes
SQL
0 vote158 views1 answer
How to find the most occuring in SQL
SQL
10 votes132 views1 answer
Oracle view dependencies
SQL