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

2 votes351 views1 answer
Oracle apex who is connected
SQL
0 vote362 views1 answer
Oracle sql date winter time
SQL
0 vote383 views1 answer
Mysql random number between 1 and 100
SQL
0 vote344 views1 answer
Sql server obtener nombre sin espacios en blanco
SQL
5 votes357 views1 answer
Find table from column name in sql
SQL
3 votes412 views1 answer
Oracle undo tablespace schema
SQL
0 vote455 views1 answer
Current month transactions in mysql
SQL
0 vote366 views1 answer
Java sql connection
SQL
2 votes398 views1 answer
Oracle Column Names of a table
SQL
0 vote351 views1 answer
Uncomment listen_address=localhost
SQL