Mysql alter table add index

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

Mysql alter table add index

ALTER TABLE TABLE_NAME ADD INDEX `index_name` (`column_name`)

Source: riptutorial.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 vote155 views1 answer
Sp help text in postgresql
SQL
0 vote128 views1 answer
[object Object]: BY KimbleOne__DeliveryGroup__c, CreatedDate ^ ERROR at Row:1:Column:142 field 'CreatedDate' can not be grouped in a query call
SQL
10 votes139 views2 answers
Mysql drop database if exists
SQL
0 vote130 views1 answer
Enable full text search mysql
SQL
1 vote132 views1 answer
Oracle create program if no exists
SQL
0 vote129 views2 answers
Update Query in SQL Server Table - NAYCode.com
SQL
0 vote148 views1 answer
Function plsql
SQL
7 votes128 views1 answer
Oracle set sequence value to max(id)
SQL
15 votes134 views2 answers
Open postgress in terminal mac
SQL
0 vote127 views1 answer
Sql select all tables from database change url
SQL