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 vote209 views1 answer
Print intervals of 15 minutes in sql query
SQL
0 vote220 views1 answer
How to get distinct sets of rows using SQL (Oracle)?
SQL
1 vote220 views2 answers
How to add amount between date in sql
SQL
0 vote214 views1 answer
Qt qsql check if table exist
SQL
3 votes231 views1 answer
DB: in eloquent using sql
SQL
1 vote221 views1 answer
Moodle query first user access
SQL
2 votes235 views2 answers
Sqlalchemy return id after insert
SQL
31 votes202 views3 answers
Sql count(*)
SQL
1 vote203 views1 answer
Autocommit mysql
SQL
3 votes236 views2 answers
Order by postgresql
SQL