Create Index in the MySQL Table

Indexes allow the database application to find data fast, without reading the whole table.The CREATE INDEX statement is used to create indexes in tables.

CREATE INDEX Syntax

CREATE UNIQUE INDEX Syntax

Example :
Create an index named username_index for the field username:

If you want to create an index on a combination of columns, you can list the column names within the parentheses, separated by commas as shown below

you can find more about index at : http://dev.mysql.com/doc/refman/5.0/en/create-index.html

I hope you like this Post, Please feel free to comment below, your suggestion and problems if you face - we are here to solve your problems.

0 0 vote
Article Rating
Subscribe
Notify of
guest
0 Comments
Inline Feedbacks
View all comments
DMCA.com Protection Status
0
Would love your thoughts, please comment.x
()
x