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 votes336 views1 answer
Sql server check version
SQL
0 vote328 views1 answer
Search In the Data using ObjectName
SQL
1 vote344 views1 answer
Ubuntu mysql cannot connect to database server remote
SQL
22 votes411 views1 answer
Mysql workbench
SQL
0 vote321 views1 answer
How to count with except in psql
SQL
0 vote328 views1 answer
Mysql select last 15 minutes
SQL
0 vote337 views1 answer
Horizontal join sqlite
SQL
0 vote364 views1 answer
Oracle swap partition
SQL
1 vote317 views1 answer
How to select random rows from table
SQL
4 votes414 views4 answers
Remove duplicate old value in mysql
SQL