How to create and usage index

[samansk]

I want to create Mysql index for faster searching data but I never make before .How can I make it?

 

[Roland]

Try it with 'Create Index':
Syntax: CREATE [UNIQUE] INDEX Index ON Table (Field[,...])
Example: CREATE UNIQUE INDEX stafflno_key ON stafftable(staff_id)

Notice that indexed fields have to be NOT NULL.

Hope it helps.

 

[samansk]

How to use after create index and how to maintain it?

 

[Roland]

Well, after indexing, your access will be faster ;-)
Try

http://www.mysql.com/doc/I/n/Indexes.html

 

[samansk]

Thanks everyone.