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

1 vote243 views2 answers
Sql queries practice
SQL
3 votes242 views2 answers
Brew restart mysql
SQL
0 vote240 views1 answer
How to check xampp mysql password
SQL
2 votes237 views2 answers
Oracle no data found error code
SQL
0 vote278 views1 answer
Delete from table where length sql
SQL
0 vote233 views1 answer
Find number of entries sql
SQL
0 vote237 views1 answer
PSQL qith variables
SQL
4 votes314 views2 answers
Delete all table oracle
SQL
0 vote224 views2 answers
Mysql slave status
SQL
1 vote251 views1 answer
SQL query to get all table records count from a database
SQL