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

5 votes136 views3 answers
String concatenation sql server
SQL
0 vote136 views1 answer
Where date major today mysql
SQL
0 vote126 views1 answer
Mysql group rows with same value
SQL
3 votes136 views1 answer
Oracle transaction commit rollback example
SQL
-1 vote129 views1 answer
Mysql #1064 error
SQL
1 vote88 views1 answer
Oracle character set
SQL
2 votes130 views1 answer
Check isolation level in mysql
SQL
0 vote163 views1 answer
Mysql get hour from datetime
SQL
0 vote139 views1 answer
How to insert multiple rows in mysql using laravel
SQL
2 votes140 views3 answers
Copy data from one table column to another table column in sql
SQL