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 vote297 views1 answer
Mysql backup certain tables workbench
SQL
0 vote299 views1 answer
Copy data from one postgres container to another
SQL
0 vote269 views1 answer
Sql server current time without date
SQL
1 vote268 views1 answer
How to give access to database in postgresql server to another user
SQL
-1 vote285 views1 answer
Ssql to lowercqse
SQL
2 votes285 views3 answers
Current month mysql query
SQL
0 vote314 views1 answer
Mysql change default collation
SQL
1 vote286 views1 answer
Sql run multiple updates in one query
SQL
5 votes286 views3 answers
Select tables from mysql database
SQL
3 votes320 views3 answers
Illuminate database queryexception could not find driver (sql select * from
SQL