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

3 votes257 views2 answers
Oracle privileges users
SQL
0 vote173 views1 answer
Dnsmasq.conf location macos
SQL
0 vote231 views1 answer
Compress sql file database ubuntu
SQL
0 vote188 views1 answer
Pl sql disable trigger
SQL
2 votes183 views1 answer
Mysql how to store lat,lng
SQL
1 vote203 views1 answer
Create new table in SQL from old table with data
SQL
4 votes246 views1 answer
Oracle change nls_date_format permanently
SQL
3 votes193 views2 answers
Get current year sql
SQL
1 vote202 views1 answer
Blob datatype in mysql
SQL
23 votes200 views1 answer
How remove column in mysql
SQL