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 vote219 views1 answer
Query for backup a database at another location in file system
SQL
0 vote208 views1 answer
Oracle last connexion
SQL
0 vote204 views1 answer
Oserror mysql_config not found virtualenv
SQL
0 vote265 views1 answer
How to get column name in db from an sqlalchemy attribute model
SQL
1 vote208 views1 answer
Sql server update column based on another table
SQL
0 vote232 views1 answer
Get create sql of hibernqte entity
SQL
0 vote248 views1 answer
MySQL update with subquery
SQL
0 vote257 views1 answer
SQL joins in python
SQL
0 vote219 views1 answer
How to print sql query
SQL
1 vote200 views1 answer
Quit mysql
SQL