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 vote145 views1 answer
Sql string function update replace
SQL
0 vote143 views1 answer
Table values functions in SQL
SQL
0 vote149 views1 answer
Mysql pad zeros
SQL
4 votes167 views2 answers
Dbms output
SQL
7 votes138 views1 answer
Append column sql
SQL
0 vote136 views1 answer
Sql database connectivity
SQL
1 vote166 views1 answer
Sql and
SQL
0 vote147 views1 answer
Sql remove last 2 digit
SQL
0 vote274 views1 answer
Generate a random otp in sql server
SQL
10 votes138 views4 answers
Sql pagination
SQL