MySQL Forums
Forum List  »  Quality Assurance

Re: What does "KEY" do?
Posted by: John H. Embretsen
Date: July 22, 2008 06:48AM

More information about indexes in MySQL is available in the manuals:

Section 7.4.5. How MySQL Uses Indexes:
http://dev.mysql.com/doc/refman/5.1/en/mysql-indexes.html

Section 12.1.7. CREATE INDEX Syntax
http://dev.mysql.com/doc/refman/5.1/en/create-index.html

And yes, KEY is "normally a synonym for INDEX", see http://dev.mysql.com/doc/refman/5.1/en/create-table.html

See also http://en.wikipedia.org/wiki/Index_%28database%29

Options: ReplyQuote


Subject
Views
Written By
Posted
3108
July 15, 2008 11:09PM
Re: What does "KEY" do?
1997
July 22, 2008 06:48AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.