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

0 vote204 views1 answer
Mysql workbench search all tables
SQL
0 vote233 views1 answer
Query archive mode
SQL
8 votes240 views2 answers
Grant all privileges database postgres to user
SQL
1 vote235 views1 answer
Postgres power
SQL
1 vote251 views3 answers
How to create a table structure from another table in mysql
SQL
0 vote232 views1 answer
Sql server user permissions and roles
SQL
11 votes230 views4 answers
Round in sql
SQL
0 vote213 views1 answer
Mysql get 2nd value in comma separated list
SQL
57 votes364 views6 answers
Mysql alter table add column
SQL
0 vote209 views1 answer
Sql min
SQL