How to create index mysql

Create index mysql

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 vote153 views1 answer
Create api project in visual studio 2019 and sql server
SQL
0 vote177 views1 answer
Which sql statement would you use to remove a view called emp_dept_vu from your schema?
SQL
2 votes293 views1 answer
Tsql copy table
SQL
0 vote221 views1 answer
Show all mongodb
SQL
22 votes282 views4 answers
Mysql date format
SQL
1 vote205 views1 answer
Wherein mysql
SQL
0 vote193 views1 answer
How to access to mysql without root
SQL
2 votes127 views1 answer
Foreign key example in dbms
SQL
0 vote186 views1 answer
Cube oracle
SQL
3 votes161 views1 answer
Pl sql check if variable is empty
SQL