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

2 votes370 views3 answers
Current setting postgres timezone
SQL
7 votes346 views1 answer
Set sequence value oracle
SQL
0 vote351 views1 answer
Less than and between in sql query
SQL
2 votes346 views1 answer
Oracle index size calculation
SQL
1 vote339 views1 answer
Create temporal table in sql
SQL
4 votes381 views1 answer
How to drop a database in sql server when it is in use
SQL
-1 vote379 views1 answer
Sql select data from one database and insert into a different database
SQL
0 vote343 views1 answer
Sql datediff db2
SQL
0 vote334 views2 answers
Mysql output csv
SQL
0 vote353 views1 answer
Mysql foreach insert
SQL