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

7 votes221 views1 answer
Show line number in sql server
SQL
0 vote206 views1 answer
How to do a function to return row type from a table in pl/sql
SQL
0 vote207 views1 answer
Pl sql turn off variable substitution
SQL
7 votes230 views1 answer
Sql disable safe mode
SQL
0 vote180 views1 answer
Oarcale list objects
SQL
5 votes193 views6 answers
In operator sql
SQL
0 vote180 views1 answer
Mysql set column equal to another automatic
SQL
0 vote236 views1 answer
Pl sql round
SQL
0 vote182 views1 answer
Insert set mysql
SQL
5 votes190 views3 answers
Oracle first day of last year
SQL