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 vote123 views1 answer
Soql more than today
SQL
0 vote165 views1 answer
How to connect to xampp sql server on windows cmd
SQL
1 vote139 views1 answer
Oracle create_program
SQL
4 votes138 views3 answers
Sql drop primary key
SQL
1 vote126 views2 answers
Grab part of a string sql
SQL
0 vote127 views2 answers
Add colum in sql
SQL
8 votes147 views1 answer
Database backup in mysql server recovery
SQL
0 vote129 views1 answer
Postgres can integer fields be negative
SQL
0 vote123 views1 answer
Sql constarint
SQL
1 vote145 views1 answer
Ubuntu access database from terminal
SQL