Index in mysql

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

Index in mysql

Ex. Explain select * from user where name = ‘kinjal’	#here explain is used for finding that how much time it takes to find name, how much rows in search.

Mysql select statement after index

   SELECT * FROM table1 USE INDEX (col1_index,col2_index)
    WHERE col1=1 AND col2=2 AND col3=3;

Source: stackoverflow.com

What is the use of index in mysql table

Indexes are used to find rows with specific column values quickly. Without an index, MySQL must begin with the first row and then read through the entire table to find the relevant rows. The larger the table, the more this costs.

Similar codes

16 votes208 views3 answers
T-SQL Add Column
SQL
0 vote268 views1 answer
Alter database name script
SQL
0 vote218 views1 answer
Sql show founctions
SQL
0 vote238 views1 answer
Delete ids between sql
SQL
1 vote188 views1 answer
Postgres grant read only access to database
SQL
9 votes197 views3 answers
Sql delete where in
SQL
5 votes217 views1 answer
Oracle nls parameters
SQL
0 vote183 views1 answer
Get number of rows in every table mysql
SQL
2 votes190 views1 answer
Cast string to datetime mysql
SQL
3 votes191 views1 answer
Select nextval from sequence sql
SQL